Tuesday, February 6, 2007

Column List for Table

I know you can use sp_help TableName for this but sometimes you just want a list with only column names.

SELECT
C.Ordinal_Position
, C.Column_Name
FROM
Information_Schema.Columns AS C
WHERE
C.Table_Name = 'TableName'
ORDER BY
C.Ordinal_Position

No comments: