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 to filter records of table in SQL SERVER?

1081

What are sql server functions?

973

Do you know the capabilities of cursors?

1141

What is an indexing strategy?

997

Do you know what is a with(nolock)?

1047

How do you delete duplicate rows in sql server?

951

What are the advantages of using third-party tools?

986

What command is used to create a database in the sql server and how?

1169

How to turn on the mssql api module in php?

1067

Explain the architecture of ms sql reporting service?

913

What are functions in the sql server?

1204

What is the difference between substr and charindex in the sql server?

1087

When multiple after triggers are attached to sql table, how to control the order of execution?

1041

What are the differences between clustered and non-clustered index?

1021

Equi join and non equi join is possible with sql server?

1010