select count(*) from syscolumns where id=(select id from Sysobjects where

how to find number of columns in a table in sql server 2000
and 2005 also

Question Posted / bhaskar

Answer Posted / bhaskar

select count(*) from syscolumns where id=(select id from
Sysobjects where [name]='Table_Name')

Is This Answer Correct ?

13 Yes

3 No

Please Help Members By Posting Answers For Below Questions

How to provide column names in insert statements in ms sql server?

1090

What are the types of subscriptions in SQL Server replication?

973

which table keeps the locking information? : Sql server administration

1022

Explain following error properties?

969

System requirements for sql server 2005 express edition?

960

What are recommended options to be used while using db mirroring? : sql server database administration

1087

what is difference between NULL and ISNULL in SQL Server 2008?

973

How do I find my localdb version?

946

What is difference between clustered index and non clustered index?

1038

What is data set in report?

127

What is the architecture of ms sql reporting service?

935

What are the different types of data sources in ssrs?

190

What is an entity-relationship diagram (erd)?

1138

What do you understand by recursive stored procedure?

883

How to change the system date and time from SQL Plus Terminal ?

1168