Home Forums SQL Server 2008 SQL Server 2008 - General Suggestion on Foreign Key Constraint RE: Suggestion on Foreign Key Constraint

  • February 8, 2011 at 11:22 am

    #1283904

    zubairmasoodi (2/8/2011)

    Thanks for your quick reply

    I quote you

    "2 Improves db speed" and this is my primary motivation., but i wonder architecturally if its a good practice.

    Limitation here i see is , will this constraint allow me to delete a record in UserInfo table ? or will it just say

    Cannot truncate table 'UserInfo' because it is being referenced by a FOREIGN KEY constraint.

    Thanks

    Zubair

    Here's 1 of my favorite mantra. There's no point in having the wrong answer fast.

    I'd strongly recommend to use then in dev and once you're 1 000 0000 0000 000 000 000 000 000 000 % sure that you application is coded correctly, then you can remove the fks.