List my SQL table column/field names

Code Title: List my SQL table column/field names
Language: SQL Server
Database: MS SQL

Description:

You can do it for all the table in one shot
using the information_schema views (shoul dbe easier to export to Excel). The code is below, in the code view.
 

Added: 09/29/2008
Profile: Syed
User Name: syed

Recent Entries by Author:
Coming Soon!

Note: Please, always give credit to author for his/her work, if used in production environment.

Code

SELECT COLUMN_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE (TABLE_NAME = 'your table name')

 

 

 


© 2010 Splitzer | CFShare Code Library (v 1.5.3)