How do I drop a foerign key in mssql?
Posted
by mmattax
on Stack Overflow
See other posts from Stack Overflow
or by mmattax
Published on 2008-09-18T14:50:36Z
Indexed on
2010/06/01
17:43 UTC
Read the original article
Hit count: 214
Filed under:
sql-server
|tsql
I have created a foreign key (in mssql / tsql) by:
alter table company add CountryID varchar(3);
alter table company add constraint Company_CountryID_FK foreign key(CountryID)
references Country;
I then run this query:
alter table company drop column CountryID;
and I get this error:
Msg 5074, Level 16, State 4, Line 2
The object 'Company_CountryID_FK' is dependent on column 'CountryID'.
Msg 4922, Level 16, State 9, Line 2
ALTER TABLE DROP COLUMN CountryID failed because one or more objects access this column.
alter table company drop foreign key Company_CountryID_FK;
alter table company drop column CountryID;
What do I need to do to drop the CountryID column?
Thanks.
© Stack Overflow or respective owner
