FROM dbc.tables T, dbc.COLUMNS C
WHERE T.Databasename = C.Databasename
IN ( 'Table_11_VW','Table_12_VW','Table_13_VW','Table_14_VW','Table_15_VW','Table_16_VW','Table_17_VW'
AND LOWER(C.ColumnName) = 'createdate'
AND T.DatabaseName = 'Tables_VIEW'
ORDER BY 1,2
SELECT MAX(createdate),MIN(createdate),COUNT(*) FROM Table_11_VW;
SELECT MAX(createdate),MIN(createdate),COUNT(*) FROM Table_12_VW;
SELECT MAX(createdate),MIN(createdate),COUNT(*) FROM Table_13_VW;