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 the cartesian product of the table?

958

What are the new features in sql server 2016?

969

What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?

1000

What is the difference between mysql and mysqli?

1206

What are sub reports?

203

How and why use sql server?

1014

tell me what is blocking and how would you troubleshoot it? : Sql server database administration

905

how you can configure a running aggregate in SSRS?

190

What is NOT NULL Constraint in sql server 2012?

1003

How to get @@error and @@rowcount at the same time?

1035

What is user-defined functions? What are the types of user-defined functions that can be created?

1036

What are the advantages of using stored procedures in sql server?

1013

How do I setup a sql server database?

1078

How does normalization work?

925

What is delete query?

945