3-sql Server 2008 Using SQL statements to delete constraints

The basic syntax is:

ALTER Table Table Name

DROP CONSTRAINT constraint name 1, constraint name 2 ...

If you delete a constraint, you do not need the name of the constraint after the comma, and if you delete two and more than two constraints, you must separate them with commas.

Use the employee table in the previous section to delete the Fk_personid foreign KEY constraint and the Pk_employeeid PRIMARY KEY constraint in the employee table, with the following code:

 Use -- using the Personinfo database GO ALTER TABLE Employee -- Delete Fk_personid foreign KEY constraints and Pk_employeeid primary KEY constraints in the employee table DROP CONSTRAINT Fk_personid,pk_employeeid GO

Results:

3-sql Server 2008 Using SQL statements to delete constraints