select statements

Question

select statements

charipg

SSCrazy Eights

Points: 9888
More actions
August 12, 2009 at 3:11 pm

#385170

what is the select statement for retriving only column names in a table.

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

RBarryYoung SSC Guru Points: 143329 More actions · Answer 1

SELECT * FROM YourTableName WHERE 1=0

[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung [font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]

mtassin SSC-Insane Points: 23099 More actions · Answer 2

select

a.[name]

from

sys.columns a join sys.tables b on

a.object_id = b.object_id

where

b.[name] = ''

--Mark Tassin
MCITP - SQL Server DBA
Proud member of the Anti-RBAR alliance.
For help with Performance click this link[/url]
For tips on how to post your problems[/url]

charipg SSCrazy Eights Points: 9888 More actions · Answer 3

charipg

SSCrazy Eights

Points: 9888

August 12, 2009 at 3:43 pm

#1038354

thanks...............

charipg SSCrazy Eights Points: 9888 More actions · Answer 4

what is select statement for retreiving the list of table in a database.

charipg SSCrazy Eights Points: 9888 More actions · Answer 5

got it.........

select * from sys.tables

thanks.......................

RBarryYoung SSC Guru Points: 143329 More actions · Answer 6

Glad we could help ... 😉

[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung [font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]