Post reply

system table & foreygn key

  • July 10, 2006 at 9:01 am

    #169098

    someone know which is the table system where are stored the foreygn key constraint?

    tnx in advance!

  • July 13, 2006 at 8:00 am

    This was removed by the editor as SPAM

  • July 14, 2006 at 3:52 pm

    #649386

    Here you go:

    select

    Name, object_name(parent_obj), xtype

    from

    sysobjects where

    id

    in (select constid from sysconstraints)

    order

    by object_name(parent_obj)

     

    It returns the Constraint, the table name and the constraint type.

    Hope that helps.

     

    Daniel

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

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