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
HR Interview Questions
16 years ago
No comments:
Post a Comment