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 constraints,”above.
For example, to drop the constraint created previously:
alter table titles drop constaint advance_chk
For detailed information about a table’s constraints, see “Using sp_helpconstraint to find a table’s constraint information”.
