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)
Thursday, July 30, 2009
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment