Post reply

how to remove a foreign key for a table in sql server 2005

  • February 10, 2009 at 5:00 am

    #126360

    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

    #941097

    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

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • February 10, 2009 at 6:09 am

    #941117

    Thank You Lowell

  • February 10, 2009 at 10:13 pm

    #941800

    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