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
Tuesday, February 6, 2007
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment