Post reply

reference constraint

  • September 25, 2009 at 11:29 am

    #214858

    Hi.

    I´m triying to delete data from a table i get a conflict with reference constraint.

    How can i delete data from table 'A' and any other table that share the data ??

    thanks.

  • September 25, 2009 at 12:26 pm

    #1058616

    Usually, delete the data in the referring tables first. Alternatively you could set up your foreign key constraints with cascading deletes. This is considered a dangerous approach, so it's not recommended.

    ----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software

  • September 25, 2009 at 4:21 pm

    #1058687

    Grant Fritchey (9/25/2009)

    Usually, delete the data in the referring tables first. Alternatively you could set up your foreign key constraints with cascading deletes. This is considered a dangerous approach, so it's not recommended.

    thanks!

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply