-
List all user tables and columns in a database.
October 16, 2007 04:02 PM
SQL
List all columns in all tables in a SQL Server 2000 database.
SELECT SO.NAME, SC.NAME
FROM SYSOBJECTS SO INNER JOIN SYSCOLUMNS SC
ON SO.ID = SC.ID
WHERE SO.XTYPE = 'U'
ORDER BY SO.NAME, SC.NAME
List all columns in all tables in a SQL Server 2005 database.
SELECT SO.NAME, SC.NAME
FROM SYS.OBJECTS SO INNER JOIN SYS.COLUMNS SC
ON SO.OBJECT_ID = SC.OBJECT_ID
WHERE SO.TYPE = 'U'
ORDER BY SO.NAME, SC.NAME
Posted by: Anson
Comments
Add Your Own Comment