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
Removing a constraint from a table
Labels:
SQL Server
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment