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

What are some of the pros and cons of not dropping the sql server builtinadministrators group? : sql server security

981

When you use @@error and try-catch?

1045

What do you mean by data manipulation language?

1019

How to stop a loop early with break statements in ms sql server?

1020

What are the dis_advantages of stored procedures, triggers, indexes?

2226

What are the essential components of sql server service broker?

1020

How to reaname table name without using sp_Rename in sql server..?

996

Does server sql treat char as a variable-length or fixed-length column?

1036

if you encounter this kind of an error message, what you need to look into to solve this problem? : Sql server database administration

985

Why I am getting "the microsoft .net framework 2.0 in not installed" message?

982

How to add additional conditions in SQL?

1023

What are examples of triggers?

1088

as a part of your job, what are the dbcc commands that you commonly use for database maintenance? : Sql server database administration

909

What is the difference between migration and upgradation in sql server?

1097

What is built-in function?

1009