Thursday, March 26, 2009

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.
Here is another location, purportably of the same info, but I found differences, so wise to consult both - "Schema Rowsets":

No comments: