SELECT count(*) NoOfColumns FROM SYSCOLUMNS WHERE id= (Select id from SYSO

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

Question Posted / jerry joseph

Answer Posted / jerry joseph

SELECT count(*) NoOfColumns FROM SYSCOLUMNS
WHERE id= (Select id from SYSOBJECTS where name = 'TableName')

Is This Answer Correct ?

14 Yes

6 No

Please Help Members By Posting Answers For Below Questions

Can you always create a cache of a report?

178

What are the types of normalization?

1077

What is the Control Flow in SSIS

1150

What is the difference between local and global temporary tables?

1199

Does partitioning ssd reduce performance?

930

How to maintain a fill factor in existing indexes?

1057

Can you explain what is sql server english query?

1055

Can we use where and having clause together?

1099

what changed between the previous version of sql server and the current version? : Sql server database administration

1054

How many tables can be joined in SQL Server?

1115

What are the types of ssrs?

149

What is 2nf in normalization?

1058

What are the new scripting capabilities of ssms? : sql server management studio

1122

What is amo? : sql server analysis services, ssas

1137

What is pivot and unpivot?

1066