Displaying col names from a table

[it2hill]

Is there a way to display the col names of a table?

I know you can do a select * and limit with a where that is false like

select *
from my_table
where 1 > 2

Is there a sp or anything that would show the information?

Thanks,

Shane

 

[RajD]

Try this,

select name from syscolumns where id = object_id("my_table&quot order by colid
RajD

 

[it2hill]

Thanks!!

Shane

 

[JMCraig]

There's another (AFAIK, undocumented) function that you can use if you're wanting to have the information in the form of column headings and associated metadata (e.g. to use a java.sql.ResultSetMetaData object):

set fmtonly on
/* returns only the "format" information; no data */
select * from table_in_question
set fmtonly off

HTH,

JMC J M Craig
Alpha-G Consulting, LLC

http://alphagconsulting.bizhosting.com

nsjmcraig@netscape.net

 

[bpedaci]

sp_help tablename?