May 26, 2005 at 7:06 am
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
May 26, 2005 at 7:17 am
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.
May 26, 2005 at 7:24 am
That's it
Thanks
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy