select count(*) from information_schema.columns where table

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

Question Posted / rajkumar v

Answer Posted / rajkumar v

select count(*) from information_schema.columns where
table_name='Emp'

EMP table name

Is This Answer Correct ?

3 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Do you have any idea about the tcl commands?

956

When I delete any data from a table, does the sql server reduce the size of that table?

1005

Who is the owner of a schema in ms sql server?

1070

Does partitioning improve performance?

965

Explain nested stored procedure. Syntax and an example for create nested stored procedure?

920

How to assign new column names in a view?

910

Does group by sort data?

888

What are different types of subquery?

1232

What is difference between materialized view and view?

905

What is difference between line feed ( ) and carriage return ( )?

891

Explain a checkpoint?

1019

What is the difference between push and pull subscription? : sql server replication

1207

What are ddl (data definition language) statements for tables in ms sql server?

1093

Is sql server free?

910

What is RMS migrations?

2128