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 meant by indexing?

939

How to convert binary strings into integers in ms sql server?

962

Why do we backup Active Directory ?

996

difference between Clustered index and non clustered index ?

934

What is the security principal at the server level that represents your session?

964

What are the different subsets of sql?

1471

What is the function of inner join?

1004

What happens when converting big values to numeric data types?

1029

How to create nested stored procedure?

949

What is openrowset sql server?

1061

can a database be shrunk to 0 bytes, if not, why? : Sql server administration

1116

Do you know what are different types of replication in sql server?

1036

What is the difference between web edition and business edition?

111

How to list all stored procedures in the current database using ms sql server?

1054

What do you mean by a dependent functionality in a build?

1063