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

Does sql server 2016 have ssms?

525

What are the five major components of a dbms?

520

State the difference between local and global temporary tables?

579

What is a collation in ms sql server?

558

What is join and name different type of joins?

588

What does the update command do?

625

Where in ms sql server is ’100’ equal to ‘0’?

612

Explain about Views?

614

Explain what stored procedure sp_replcounters is used for? : sql server replication

1017

How to use order by with union operators in ms sql server?

584

What are commit and rollback in sql?

573

What is cursors?

651

What is RMS migrations?

1713

How do I install sql server?

476

How dts is used to extract, transform and consolidate data?

604