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 do you understand by change data capture?

1033

What is the difference between rank and dense_rank?

1092

What is parameterized reports in ssrs ?

149

How to rename an existing column with sql server management studio?

1001

Explain what is log shipping?

1141

When does a workload on SQL Azure get throttled?

131

What are the key configuration files for sql server reporting services ?

170

Mention a few common trace flags used with sql server?

940

What is trigger and different types of Triggers?

1151

What are statistics?

1007

What is an expression in ms sql server?

1083

How to get a list of columns in a view using "sys.columns" in ms sql server?

995

what are candidate key, alternate key and composite key? : Sql server database administration

921

Does sql server 2000 full-text search support clustering?

870

What is schemabinding a view?

923