SQL Server T-SQL Schema Introspection

O'Reilly's "SQL Cookbook" by Anthony Molinaro is awesome, and chapter 5 "Metadata Queries" is very helpful.

A complete list of the metadata table columns for SQL Server are found at "SQL Server Schema Collections" at msdn.microsoft.com.

http://msdn.microsoft.com/en-us/library/ms254969(loband).aspx

Here is another location, purportably of the same info, but I found differences, so wise to consult both - "Schema Rowsets":

http://msdn.microsoft.com/en-us/library/ms712921(VS.85).aspx