( select name, type, is_nullable, max_length, default_value, (priority+1) as priority, human_name from variables.columns_properties where name!= and priority >= union select name, type, is_nullable, max_length, default_value, as priority, human_name from variables.columns_properties where name= union select name, type, is_nullable, max_length, default_value, priority, human_name from variables.columns_properties where name<> and priority < ) order by priority asc; ( select name, type, is_nullable, max_length, default_value, priority, as human_name from variables.columns_properties where name= union select name, type, is_nullable, max_length, default_value, priority, human_name from variables.columns_properties where name<> ) ) order by priority asc; insert into #variables.table# ( #name#, ) values ( , ) select max(id) as id from #variables.table# update #variables.table# set #name# = #name# = #name# = , where #variables.pk#= delete from #variables.table# where #getPK()# = '#this[getPK()]#' select #variables.table#.#variables.pk#, #valuelist(local.columns_properties.qualified_name)# from #variables.table# #variables.autoload_relationship_joins# where #preservesinglequotes(filter)# order by #arguments.orderBy# select #variables.table#.#variables.pk#, #valuelist(local.columns_properties.qualified_name)# from #variables.table# #variables.autoload_relationship_joins# where #variables.table#.#variables.pk# = #arguments.sqlQueryText# select human_name from variables.columns_properties where name = '#columnName#' > select character_maximum_length, column_name, data_type, ordinal_position, column_default, is_nullable from information_schema.columns where table_name = '#arguments.table#' and column_name in (#listqualify(local.column_list,"'")#) order by ordinal_position select * from variables.columns_properties where name<>'id' and is_in_original_table = 1 and name= order by priority asc;