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

How to concatenate two strings in SQL Server.

1203

Can a table be moved to different filegroup?

1025

Define self join?

1078

Can foreign key be deleted?

979

Write a program to fetch first 10 records from a file?

1062

What are the different types of sql server replication? : sql server replication

1367

What is a trigger and types of a trigger?

1027

What is the recommended total size of your memory optimized tables?

1004

Can you import Microsoft Excel data to SSRS?

135

What is the difference between deallocate cursor and close cursor?

1333

What according to you is the difference between mysql and sql server performance?

1143

How would we use distinct statement? What is its use?

1123

How do you delete a data source?

1049

Explain what is analysis service repository?

1049

What is a derived table?

991