February 10, 2009 at 5:00 am
Hi All ,
I am i need of how to remove a foreign key for a table in sql server 2005,
Please tell the query for it
Thanks and Regards
Sevamariappan.c
February 10, 2009 at 5:10 am
sp_help the table, and find the name of the Foreign key you want to drop.
issue the drop command like this:
sp_help gmact
alter table gmact drop constraint FK__GMACT__AACCOMPLT__66960AE6
Lowell
February 10, 2009 at 6:09 am
Thank You Lowell
February 10, 2009 at 10:13 pm
Hi Lowell,
How to Add the constraint Again to the same table.
Regards,
Selvamariappan.c
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply