DROP COLUMNS AND CONSTRAINT WITH ALTER STATEMENT 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