Thursday, July 30, 2009

Dropping a Table Constraint

Synatx:
ALTER TABLE Table_name
DROP CONSTRAINT Constraint_name
Example
ALTER TABLE employee
DROP CONSTRAINT FK_DEDUCTION_ID

Here simply drop a foregin key Constraint between two relational tables (ie., employee and Deduction)

No comments:

Post a Comment