about number of columns in a table

[bhmadhukar]

hai friends,

i created a table with a name 'emp'. And it has 4 columns. Now my question is,
tell me a query, procedure or what ever available, how to get the number of columns from a table.

thanx in advance.

[ck9663]

hai friends,

i created a table with a name 'emp'. And it has 4 columns. Now my question is,
tell me a query, procedure or what ever available, how to get the number of columns from a table.

thanx in advance.

try:

select count(*) from syscolumns where id in (select id from sysobjects where name = 'YourTableName')

-- CK