Drop a restraint in T-SQL.

Often before you may drop a column you will need to drop a restraint. An example:

ALTER TABLE Whatever
DROP NameOfMyRestraint