]> error() requires a QName literal! /****************************** * Drop Tables by inverse order of creation: z=import, y=no-dependency, m=foreign-keys, a=no foreign key DROP TABLE ****************************** * Summarize min and max values for each column of each table SELECT '' as name, COUNT(*) as Count ****************************** * Count each ID values [varchar(100)] DROP TABLE domain_values CREATE TABLE domain_values ( tbl varchar(100), col varchar(100), val varchar(100), cnt int, ) &nl; SELECT col, val, sum(cnt) as count, min(tbl) as min_table, max(tbl) as max_table from domain_values where col > '' group by col, val order by col, val *******************************/&nl; IF OBJECT_ID ( '', 'U') IS NULL BEGIN CREATE TABLE (&nl; ,&nl; &nl; )&nl; END&nl; CREATE INDEX ON () INCLUDE () WITH ()&nl;