Select Count(Column_Name) As NoOfColumns From Information

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

Question Posted / kumar.t

Answer Posted / kumar.t

Select Count(Column_Name) As NoOfColumns From
Information_Schema.Columns Where table_Name='Company'

Is This Answer Correct ?

22 Yes

2 No

Please Help Members By Posting Answers For Below Questions

How do I shrink an ldf file?

561

What is Replication?

629

What is scalar user-defined function?

546

How to create and drop temp table in sql server?

585

what are user defined datatypes? : Sql server database administration

514

Do you know what is blocking?

534

What is extended stored procedures?

561

What is data source in connection string?

488

Are connections to sql server encrypted?

572

What stored by the msdb?

583

What are the diifferences between the ms sql server vs mysql?

651

Explain about the command-line tool SQLCMD?

552

Does a specific recovery model need to be used for a replicated database? : sql server replication

529

What is a system database and what is a user database?

576

What do you understand by the denormalisation?

549