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 are the types of table?

1031

1 01 101 01010

2101

How do you delete a data source?

1052

Explain about integration services of Microsoft SQL server?

1092

what is datawarehouse?

1159

How to automatically create a log when an exception is being received into SQL Server?

1361

What are database states in ms sql server?

1247

Explain the steps to create and execute a user-defined function in the sql server?

1016

Explain the categories of stored procedure?

982

How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?

1074

Explain acid?

1146

What is the difference between web edition and business edition?

113

How to create sub reports?

251

What security features are available for stored procedure?

1080

What is multilevel indexing?

981