Dushyanth Jyothi

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:

 T-SQL | 
 copy code |
?
 
1
SELECT * FROM INFORMATION_SCHEMA.TABLES

 T-SQL | 
 copy code |
?
 
1
SELECT 
2
TABLE_CATALOG,/*'TABLE_CATALOG' IS SQL-92 STANDARD NAME FOR 'DATABASE'*/
3
TABLE_SCHEMA,/*'TABLE_SCHEMA' IS SQL-92 STANDARD NAME FOR 'OWNER'*/
4
TABLE_NAME,
5
TABLE_TYPE
6
FROM INFORMATION_SCHEMA.TABLES

Further Reading/Details:
http://msdn.microsoft.com/en-us/library/ms186778.aspx