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?
LVL 1
F-J-KAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
chapmandewConnect With a Mentor Commented:
whoops...didn't think multiple drops were allowed in the same one.  You're right!

create table #t(fld1 int, fld2 int, fld3 int)

alter table #t
add constraint c_1 default(1) for fld1

alter table #t
add constraint c_2 default(1) for fld2

alter table #t
add constraint c_3 default(1) for fld3

alter table #t
drop constraint c_1, c_2, c_3
0
 
chapmandewCommented:
>>How can i drop multiple constraints at once instead of type ALTER TABLE on each constraint?

you can't.
0
 
LowfatspreadConnect With a Mentor Commented:
ALTER TABLE Customer
DROP CONSTRAINT contitleid_fk
,

DROP CONSTRAINT countryid_fk
   ,          

DROP CONSTRAINT phoneid_fk
0
 
F-J-KAuthor Commented:
Good
0
All Courses

From novice to tech pro — start learning today.