Script: Getting PK and FK info

  • Comments posted to this topic are about the content posted at

  • This query provides "To" and "From" Fields as well. I like your query for PK constraints...


    so1.Name as FKConstraint,

    so.Name as FromTable,

    sc.Name as FromColumn, so2.Name as ToTable, sc1.Name as ToColumn

    From sysobjects so (nolock)

    JOINsysforeignkeys fk (nolock) on so.[id] = fk.fkeyid

    joinsyscolumns sc (nolock) on fk.fkeyid = and fk.fkey = sc.colid

    JOINsysobjects so2 (nolock) on fk.rkeyid =

    joinsyscolumns sc1 (nolock) on fk.rkeyid = and fk.rkey = sc1.colid

    JOINsysobjects so1 (nolock) on fk.constid = = X

    Signature is NULL

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

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