CREATE TABLE IF NOT EXISTS #Request.prefix_db_agency#.pMed_Interaction_Report ( Report_ID INT NOT NULL AUTO_INCREMENT, Patient_ID INT NOT NULL DEFAULT 0, Fingerprint VARCHAR(500) NOT NULL DEFAULT '', Comm_ID INT NULL DEFAULT NULL, Interaction_Summary TEXT NULL, Date_Create DATETIME NULL, Created_By INT NOT NULL DEFAULT 0, Status INT NOT NULL DEFAULT 0, Reported_Date DATE NULL, Reported_By INT NOT NULL DEFAULT 0, Reporting_Method VARCHAR(20) NULL, Report_Notes TEXT NULL, PRIMARY KEY (Report_ID), KEY idx_patient_status (Patient_ID, Status), KEY idx_fingerprint (Fingerprint(191)) ) SELECT COUNT(*) AS col_exists FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = AND TABLE_NAME = 'pMed_Interaction_Report' AND COLUMN_NAME = ALTER TABLE #Request.prefix_db_agency#.pMed_Interaction_Report ADD COLUMN Reported_Date DATE NULL Reported_By INT NOT NULL DEFAULT 0 Reporting_Method VARCHAR(20) NULL Report_Notes TEXT NULL