Hi,

Run the below query

select name from syscolumns where id in (select id from sysobjects where
name='tablename' and type='u')

You have to just replace the tablename with the your table name for
which you want to display the column details.

Regards,
R. Mohanty
DBA
Netcradle India Ltd.

-----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