SELECT Count(*)As Coloumns FROM SysColumns Where ID = (SELECT ID FROM

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

Question Posted / vidit tyagi

Answer Posted / vidit tyagi

SELECT Count(*)As Coloumns
FROM SysColumns
Where ID =
(SELECT ID FROM SysObjects Where Name = 'TableName')

Is This Answer Correct ?

6 Yes

4 No

Please Help Members By Posting Answers For Below Questions

What is mapping schema?

1068

What is the difference between Clustered and Non-Clustered Index?

1102

What are database states in ms sql server?

1243

Explain the properties of the relational tables?

1029

How to find table changes in sql server?

1173

Difference Between ORDER BY Clause and GROUP BY Clause in SQL?

1103

Find first and last day of current month in sql server

1080

What is field with example?

976

What are the advantages of using cte?

1074

How to find the source of a table in sql server?

1037

What structure can you implement for the database to speed up table reads?

1234

Why we use trigger in sql server with example?

1013

How to defragment indexes with alter index ... Reorganize?

1137

What do you understand by replication in sql server? Mention the different types of replication in sql server.

994

What are the new security features added in sql server 2012? : sql server security

1106