Primary/Foreign Key Constraints.Relations

• Timothy Moore

  SSC Veteran

  Points: 264

  More actions

  January 8, 2007 at 5:26 pm

  #368713

  Hey all,

  I am trying to search my DB for any primary and foreign key constraints and or relations for a specific tables. how would i find this out? im a noob, sorry.

   

  Thanks

• Aaron Ingold

  SSCrazy Eights

  Points: 9070

  More actions

  January 8, 2007 at 8:47 pm

  #681935

  You can probably query sysobjects where xtype is in the primary/foreign key constraints (check BOL for the code) and join against sysdepends.

  Sorry, not near a SQL server right now or I'd test it and post it.

• ChiragNS

  One Orange Chip

  Points: 26137

  More actions

  January 8, 2007 at 9:34 pm

  #681938

  hi

  Try the sysconstraints table.

  "Keep Trying"

• shashi kant

  SSCommitted

  Points: 1659

  More actions

  January 8, 2007 at 10:45 pm

  #681941

  Hi duddy Just check the following query

  and enjoy................

  Select * from information_schema.table_constraints constraints2

  Select * from information_schema.Constraint_Column_Usage

  Select * from information_schema.referential_constraints fkeys

  Select * from information_schema.table_constraints constraints2

  Shashi Kant(MCA)

• Sugesh Kumar

  One Orange Chip

  Points: 27311

  More actions

  January 8, 2007 at 11:44 pm

  #681948

  try using sp_pkeys or sp_fkeys to get the primary and foreign key relationships.

  Cheers,
  Sugeshkumar Rajendran
  SQL Server MVP
  http://sugeshkr.blogspot.com