SQL Server Performance

Where is constraint definition stored?

Discussion in 'General Developer Questions' started by amitm79, Jan 29, 2004.

  1. amitm79 New Member

    Hi All,
    Can anybody tell me how to find the definition of all the constraints on a particular table? My requirement is to find out all the tables referring a particular table through foreign key. sp_helpconstraint can show me the names of the constrains but not the definition.

    Regards,
    amitm79
  2. Twan New Member



    sp_help has a result set for this. If you need a more elegant way they you could grab the text for sp_help and cut out the bits you don't want, rename it and save it under this different name

    Cheers
    Twan
  3. FrankKalis Moderator

  4. ChrisFretwell New Member

    Also check out the stored procedure sp_helpconstraint

    Chris

Share This Page