SELECT DISTINCT Agency_ID FROM #Request.prefix_db_lookup#.Agency WHERE Status = 0 ORDER BY Agency_ID SELECT 1 FROM #agency_db#.patients_ai LIMIT 1 SELECT COLUMN_NAME, DATA_TYPE, CHARACTER_MAXIMUM_LENGTH, IS_NULLABLE, COLUMN_DEFAULT FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = AND TABLE_NAME = 'patients_ai' AND COLUMN_NAME = 'Pt_Gender' ALTER TABLE `#agency_db#`.`patients_ai` CHANGE COLUMN `Pt_Gender` `Pt_Gender` VARCHAR(255) NULL DEFAULT NULL Alter patients_ai Pt_Gender Column - All Agencies

Alter patients_ai Pt_Gender Column

Processing Complete! The ALTER TABLE query has been executed for all agency databases.

Query Executed: 
ALTER TABLE `agency_{id}`.`patients_ai` 
CHANGE COLUMN `Pt_Gender` `Pt_Gender` VARCHAR(255) NULL DEFAULT NULL

Change: Modified Pt_Gender column to VARCHAR(255) with NULL allowed and NULL default.
Results for All Agencies:
Agency ID Database Name Status Message
#result.agency_id# agency_#result.agency_id# #result.status# #result.status# #result.status# #result.message#
Summary:
  • Total Agencies Processed: #arrayLen(updateResults)#
  • Successful: #successCount#
  • Errors: #errorCount#
  • Skipped: #skippedCount#

Completed at: #DateFormat(Now(), 'mm/dd/yyyy')# #TimeFormat(Now(), 'HH:mm:ss')#