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

What is SQL Azure Firewall?

134

How to get a list of all tables with "sys.tables" view in ms sql server?

981

what are the different ways of moving data/databases between servers and databases in sql server? : Sql server database administration

919

Explain what is row_number function?

971

How do indexes help, types?

908

What is key set driven?

892

What is a functions and types in sql server?

1010

What is collation sensitivity? Explain different types.

962

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

889

What is a file group?

1017

How to rebuild master databse?

1028

How to select an exiting database using mssql_select_db()?

909

Can I disable or restrict ssrs export formats (rendering formats)?

140

Can you explain what are the restrictions applicable while creating views? : SQL Server Architecture

850

What is the usage of sign function?

1038