IN SQLSERVER 20005 SELECT COUNT(COLUMN_NAME) FROM INFORMATION

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

Question Posted / sudhir kumar

Answer Posted / sudhir kumar

IN SQLSERVER 20005

SELECT COUNT(COLUMN_NAME) FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = N'TABLENAME'

try in sql server 2000

Is This Answer Correct ?

29 Yes

5 No

Please Help Members By Posting Answers For Below Questions

How to write a query with a left outer join in ms sql server?

931

Explain the collation?

1058

List the various tools available for performance tuning?

847

What is data source view or dsv? : sql server analysis services, ssas

954

How do we synchronize On-Premise SQL server with SQL Azure?

120

How to create a view and a stored procedure in ms sql server using "create view/procedure" statements?

940

How can delete duplicate records in cte in sql server?

914

What do mean by xml datatype?

1019

What is the difference between NOROW and LOCKROW?

2787

What sql server means?

915

What is a performance monitor?

928

What are page splits? : SQL Server Architecture

942

What is triggers and its types?

961

How to create a dynamic cursor with the dynamic option?

979

What is the tcp/ip port on which sql server runs?

1072