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 generate create function script on an existing function?

778

What is the difference between varchar and varchar types?

744

What is a non equi join?

733

what are different types of backups available in sql server? : Sql server database administration

674

How to create percentile function?

124

What is transactional replication?

713

Explain indexed views?

743

What are the different types of columns types constraints in the sql server?

735

Does sql server 2000 clustering support load balancing?

734

How efficient you are in oracle and SQL server?

806

Explain about protocol layer present in SQL server?

784

Explain what is meant by replication of database?

720

What are indexes in sql?

768

What are the authentication modes in sql server? How can it be changed?

791

What is rs.exe utility?

138