xxxxxxxxxx
ALTER TABLE schema.table
ALTER COLUMN column
DROP DEFAULT;
ALTER TABLE schema.table
ALTER COLUMN column TYPE INTEGER[]
USING array[column]::INTEGER[];
ALTER TABLE schema.table
ALTER COLUMN column SET DEFAULT '{}';
xxxxxxxxxx
ALTER TABLE table_name
ALTER COLUMN column_name datatype;
-- Example
ALTER TABLE product
ALTER COLUMN description VARCHAR(250);
xxxxxxxxxx
ALTER TABLE TableName
ALTER COLUMN ColumnName NVARCHAR(200) [NULL | NOT NULL]