query to get number of columns in table

[ankitamca85]

query to get number of columns in table ???????????

[ck9663]

try

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

-- CK

[ankitamca85]

thx....

but can u explain dis query.......i didnt get it

[ck9663]

Explain in what way? The query is a bit self explanatory...

-- CK