I have been asked to provide a list of all columns in all tables in a
database.
I have the output from "select * from sys.tables" and "select * from
sys.columns", but how do I know which columns are in what tables?

Thanks

Bob

This should do it:

SELECT TABLE_CATALOG, TABLE_NAME, TABLE_SCHEMA, COLUMN_NAME
FROM INFORMATION_SCHEMA.COLUMNS;

--
Plamen Ratchev
http://www.SQLStudio.com

thing (someone (AT) microsoft (DOT) com) writes:
SELECT s.name AS [Schema], o.name AS [Table], c.name AS [Column]
FROM sys.schemas s
JOIN sys.objects o ON s.schema_id = o.schema_id
JOIN sys.columns c ON o.object_id = c.object_id
WHERE o.type = 'U'
ORDER BY s.name, o.name, c.column_id



--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

Thank-you. You've pointed my in the right direction
"Plamen Ratchev" <Plamen (AT) SQLStudio (DOT) com> wrote

Thank-you. You've pointed my in the right direction
"Erland Sommarskog" <esquel (AT) sommarskog (DOT) se> wrote