Select Count(Column_Name) As NoOfColumns From Information

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

Question Posted / kumar.t

Answer Posted / kumar.t

Select Count(Column_Name) As NoOfColumns From
Information_Schema.Columns Where table_Name='Company'

Is This Answer Correct ?

22 Yes

2 No

Please Help Members By Posting Answers For Below Questions

Can we add an identity column to decimal datatype?

1042

What is the bookmark lookup and rid lookup?

1034

What does ss stand for sexually?

1145

What is the default value of an integer data type in sql server 2005?

998

What is an identity?

1079

What you can do to delete a table without the delete trigger firing?

1013

What is a constant or literal in ms sql server?

1100

What is the difference between clustered and non-clustered indexes in ms sql server?

1054

How to access the inserted record of an event?

1110

What is normalization process?

1240

What is equi join with example?

1230

What is an example of a primary key?

1039

Write the syntax for stuff function in an sql server?

1074

Can primary key be null?

986

how would you store your query in an SSRS report or a Database server?

167