SELECT A.*
FROM dbo.syscolumns A INNER JOIN
dbo.sysobjects B ON A.id = B.id
WHERE (B.name = 'TableName')
Replace TableName with the name of your table.
Have Fun!
-----Original Message-----
From: Bob Imperial [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 23, 2006 8:51 PM
To: CF-Newbie
Subject: OT sql question
Can someone enlighten me on how to retrieve all the column names from a
MSSQL table please?
TIA
Old Dog still trying to learn new tricks ;)
Bob
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four
times a year.
http://www.fusionauthority.com/quarterly
Archive:
http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:1979
Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
