Information schema is part of the SQL-92 standard, holds the structure if your database.
Applies to MS SQL SERVER 2008
T-SQL CODE to see the metada:
SELECT * FROM INFORMATION_SCHEMA.TABLES
SELECT TABLE_CATALOG,/*'TABLE_CATALOG' IS SQL-92 STANDARD NAME FOR 'DATABASE'*/ TABLE_SCHEMA,/*'TABLE_SCHEMA' IS SQL-92 STANDARD NAME FOR 'OWNER'*/ TABLE_NAME, TABLE_TYPE FROM INFORMATION_SCHEMA.TABLES
Further Reading/Details:
http://msdn.microsoft.com/en-us/library/ms186778.aspx
Posted: July 15th, 2009
Categories: T-SQL
Tags: database, Information schema, metadata, MS SQL Server 2008
Comments: No Comments.
Categories: T-SQL
Tags: database, Information schema, metadata, MS SQL Server 2008
Comments: No Comments.
