SELECT DISTINCT TABLE_SCHEMA FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA LIKE 'agency_%' AND TABLE_NAME = 'files' ORDER BY TABLE_SCHEMA SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = AND TABLE_NAME = 'files' AND COLUMN_NAME = 'Cert_Start' ALTER TABLE #TABLE_SCHEMA#.files ADD COLUMN Cert_Start DATE NULL, ADD COLUMN Cert_End DATE NULL