Drop Multiple Constraints - MS SQL Server/T-SQL
ALTER TABLE Customer
DROP CONSTRAINT contitleid_fk
ALTER TABLE Customer
DROP CONSTRAINT countryid_fk
ALTER TABLE Customer
DROP CONSTRAINT phoneid_fk
How can i drop multiple constraints at once instead of type ALTER TABLE on each constraint?
DROP CONSTRAINT contitleid_fk
ALTER TABLE Customer
DROP CONSTRAINT countryid_fk
ALTER TABLE Customer
DROP CONSTRAINT phoneid_fk
How can i drop multiple constraints at once instead of type ALTER TABLE on each constraint?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Good
you can't.