Post reply

Managing Constraints

  • March 1, 2005 at 2:42 pm

    #88138

    Is there a way to disable FK in SQL Server 2000?  Is there a sys table to look at the list of FK and other contraints?

  • March 1, 2005 at 3:00 pm

    #544712

    Disable

    ALTER TABLE ObjSQL NOCHECK CONSTRAINT ALL

    enable

    ALTER TABLE ObjSQL CHECK CONSTRAINT ALL

  • March 1, 2005 at 5:18 pm

    #544732

    Query sysconstraints to get a list of constraints in a database.  See sysconstraints in BOL.

    Greg

    Greg

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

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