primary/Foreingn/index Details for whole schema

• mayank jarsaniya

  Hall of Fame

  Points: 3532

  More actions

  May 27, 2009 at 4:29 am

  #137986

  For a perticular database

  I need select query

  first select query which gives me table_name,Column_name,Primary_key

  secound select query which gives me table_name,column_name ,foreign_table_name,foreign_column_name

  third select query which gives me table_name,column_name,index_name,index_type

• Eswin

  SSCrazy Eights

  Points: 8320

  More actions

  May 27, 2009 at 4:39 am

  #1000463

  You can use these and make your query

  select * from sysconstraints

  sp_fkeys

  sp_Pkeys

  Tanx 😀