Home Forums SQL Server 2008 T-SQL (SS2K8) Update table where there is FOREIGN KEY reference RE: Update table where there is FOREIGN KEY reference

  • You may disable constraint like that

    alter table dbo.T4 nocheck constraint fk_T4_sid

    and do what you want, but, be aware of performance problems. I blogged about it here[/url] (unfortunatelly it is only in russian, but t-sql and plans talk for them selfes).

    To have all the benefits of FK, your FK should be trusted, that means, that there should be a solid integrity of data and no missing values of fk column for pk.


    I am really sorry for my poor gramma. And I hope that value of my answers will outweigh the harm for your eyes.
    Blog: http://somewheresomehow.ru[/url]
    Twitter: @SomewereSomehow