select count(column_Name) from information_schema.columns where table

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

Question Posted / saravanan p

Answer Posted / saravanan p

select count(column_Name) from information_schema.columns
where table_name='tableName'

Is This Answer Correct ?

8 Yes

4 No

Please Help Members By Posting Answers For Below Questions

What is sqlservr.exe - process - sql server (sqlex?press)?

1096

How you would rewrite the sql query to return the customerid sorted numerically?

980

How to get the definition of a user defined function back?

1038

Why use “nolock” in sql server?

1046

What is extent? Types of extents?

1169

What is public role in sql server?

1135

Tell me the difference between clustered and non-clustered index?

928

What are the properties of sub-query?

1063

What is a file group?

1080

Explain primary key in sql server?

1006

How do you implement session management in SQL Server mode?

1084

What are drilldown reports?

152

What is the openxml statement in sql server?

1057

What are the different types of Indexes available in SQL Server?

992

Why should we go for stored procedures? Why not direct queries?

1085