Query relational data

• Douwe

  SSC Enthusiast

  Points: 101

  More actions

  May 26, 2005 at 7:06 am

  #164654

  Hi,

  I am looking for a way (SQL) to get the relational data of a database: What tabels is in a database, what fields is in a table, what is the relationships etc..

  I have looked through the Microsoft Documentation, but I don't get any examples.... please help

• Chris Hedgate

  One Orange Chip

  Points: 25041

  More actions

  May 26, 2005 at 7:17 am

  #561198

  I assume you are referring to metadata. Take a look at the INFORMATION_SCHEMA views. For example:

  SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE'

  This will show you all tables in the database. Look up INFORMATION_SCHEMA in Books Online.

  --
  Chris Hedgate http://www.hedgate.net/
  Contributor to the Best of SQL Server Central volumes
  Articles: http://www.sqlservercentral.com/columnists/chedgate/

• Douwe

  SSC Enthusiast

  Points: 101

  More actions

  May 26, 2005 at 7:24 am

  #561201

  That's it

  Thanks