how to drop column in sql server who has constraint code example
Example: 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
alter table tableName drop constraint [ConstraintName]
go
alter table tableName drop column columnName