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

Explain the difference between cross join and full outer join?

981

How to delete a database in ms sql server?

1236

How to access the inserted record of an event?

1049

What command would you use to create an index?

1056

Ways to improve the performance of a SQL Azure Database?

125

what is new philosophy for database devises for sql server 7.0? : Sql server database administration

1010

How to filter records of table in SQL SERVER?

1086

How many types of objects are there?

1009

Explain four layers of abstraction microsoft architectured?

147

How are the exceptions handled in sql server programming?

1065

What are the new scripting capabilities of ssms? : sql server management studio

1067

What are the 2 types of classifications of constraints in the sql server?

1124

how to avoid cursors? : Sql server database administration

972

How many tables can be joined in SQL Server?

1065

Describe in brief databases and sql server databases architecture.

1011