how to drop a column in sql that is a constraint code example
Example 1: sql drop column
ALTER TABLE my_schema.my_table DROP COLUMN my_column;
Example 2: How to drop columns with constraint from a table in sql script
alter table tableName drop constraint [ConstraintName]
go
alter table tableName drop column columnName