Removing a constraint from a table

Here i have given the syntax and query for removing a constraint from a table...

syntax:
------
ALTER TABLE (tbl name) DROP CONSTRAINT (CONSTRAINT name)


Eg:
--
ALTER TABLE Proddet_Details DROP CONSTRAINT  FK_PCIT_Details

No comments:

Post a Comment