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

What is a document index?

1018

explain different types of backups avaialabe in sql server? : Sql server database administration

961

What are examples of triggers?

1073

What is dbcc?

1128

Explain what is the difference between a local and a global temporary table?

989

What is the difference between count () and rowcount ()?

1013

How do I schedule a sql server profiler trace?

968

Explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?

1097

How can I check that whether automatic statistic update is enabled or not?

1034

How network traffic be reduced by using the stored procedure?

1102

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

1208

Can I disable or restrict ssrs export formats (rendering formats)?

150

what are the different types of SSRS reports?

151

What is the advantage of sql server?

1025

Explain sql delete command?

1034