Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Information_Schema
- Thread starter collierd
- Start date
INFORMATION_SCHEMA views are designed to present data from the system tables.
For instance, to view all of the column information for a table, you can issue
SELECT * FROM INFORMATION_SCHEMA.columns where table_name = 'MyTableName'
Microsoft recommends that you query the INFORMATION_SCHEMA instead of the tables directly, since the schema may change and they have promised to maintain the integrity of the views across server versions.
Read BOL for more info about the views.
HTH,
Phil Hegedusich
Senior Programmer/Analyst
IIMAK
-----------
I'll have the roast duck with the mango salsa.
For instance, to view all of the column information for a table, you can issue
SELECT * FROM INFORMATION_SCHEMA.columns where table_name = 'MyTableName'
Microsoft recommends that you query the INFORMATION_SCHEMA instead of the tables directly, since the schema may change and they have promised to maintain the integrity of the views across server versions.
Read BOL for more info about the views.
HTH,
Phil Hegedusich
Senior Programmer/Analyst
IIMAK
-----------
I'll have the roast duck with the mango salsa.
- Status
Similar threads
- Locked
- Question