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

Define Wed Edition in SQL Azure?

100

What is the difference between osql and query analyzer?

939

When do you think a developer should use sql server-based cursors?

976

How does Report Builder support Analysis Services cubes?

147

What is shared lock?

834

Why should we go for stored procedures? Why not direct queries?

1027

what exactly sql injuction.how to overcome.....

2484

How to search for a string in all stored procedure in sql server?

950

What does the update command do?

1051

What is attribute hierarchy? : sql server analysis services, ssas

961

Where cross join is used?

904

What are parameterized reports?

191

How you can minimize the deadlock situation?

980

What methods do you follow to protect from sql injection attack?

967

What is a heap?

982