Magic number #Myindex# is:  #RandRange(100000, 999999)#

---> SELECT TABLE_SCHEMA FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA like '%agency%' group by TABLE_SCHEMA select agency_id from #Request.prefix_db_lookup#.Agency where status='active' ORDER BY agency_id SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA like '%#Request.prefix_db_agency#%' AND TABLE_NAME = 'Invoices' AND COLUMN_NAME = 'Pay_Name' GROUP BY COLUMN_NAME SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA like '%#Request.prefix_db_agency#%' AND TABLE_NAME = 'Invoices_history' AND COLUMN_NAME = 'voided_claim' GROUP BY COLUMN_NAME SET innodb_strict_mode = 0; ALTER TABLE #Request.prefix_db_agency#.`patients_ai` CHANGE COLUMN `status` `status` TINYINT NULL DEFAULT '0' AFTER `id`; CREATE INDEX idx_payer_service_dates ON #Request.prefix_db_agency#.pRevenue_Code (Payer_ID, Visit_Type, Contract_Rate_Effective_Date, Contract_Rate_End_Date);