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
    amitm79, Jan 29, 2004
    #2

  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
    Twan, Jan 29, 2004
    #2

  3. FrankKalis Moderator

    FrankKalis, Jan 30, 2004
    #2

  4. ChrisFretwell New Member

    Also check out the stored procedure sp_helpconstraint

    Chris
    ChrisFretwell, Jan 30, 2004
    #2

Share This Page