Hi

SELECT S1.name from syscolumns S1,sysobjects S2
WHERe
S1.id=S2.id
AND
S2.Type='U'
AND
S2.Name='TableName'


Replace TableName with yours Table Name.

Regards


Banga Balvinder

Sr. DBA
eMind Learning Software Service Pvt. Ltd
Okhla

-----Original Message-----
From: Gaurav Vrati Noida
[mailto:mssqldba-ezmlmshield-x22506100.[Email address protected]
Sent: Monday, November 29, 2004 2:47 PM
To: LazyDBA Discussion
Subject: Query for Columns in a Table


Hi I want a query by which I can get the columns in a table.
Regards
Gaurav


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]



MS Sql Server LazyDBA home page