To drop a constraint, use:
alter table table_name drop constraint constraint_name
table_name and constraint_name have the same values as described in Adding constraintsabove.
For example, to drop the constraint created above:
alter table titles drop constaint advance_chk
To find detailed information about a table’s constraints, see “Using sp_helpconstraint to find a table’s constraint information”.
