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

Explain syntax for disabling triggers?

1044

How do you send email on SQL Server?

1065

What is candidate key with example?

976

What is a rownum?

978

What is a file group?

1092

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

1022

How do you rebuild an identity column?

949

How to generate create procedure script on an existing stored procedure?

1011

What is your recommendation for a query running very slow? : sql server database administration

1047

Can group by and orderby be used together?

1015

How to copy the tables, schema and views from one sql server to another?

1047

What are filegroups in sql server?

1061

How do I find the sql server instance name?

969

How to run queries with sql server management studio express?

1093

What are the underflow and overflow behaviors on float literals?

1113