Return to Snippet

Revision: 27774
at June 23, 2010 05:08 by ezerick


Initial Code
SELECT tab.name as TableName, col.name as ColumnName
FROM sys.tables AS tab
JOIN sys.columns AS col ON tab.object_id = col.object_id
ORDER BY tab.name, col.name

Initial URL
http://snipplr.com/developer/

Initial Description


Initial Title
SQL Server 2005 - All Cols in all Tables in a DB

Initial Tags


Initial Language
SQL