--Count of Columns SELECT COUNT(*) NO_OF_COLUMNS FROM SYS.COLUMNS WHERE

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

Question Posted / anand k

16 Answers
31028 Views
Virtusa, I also Faced
E-Mail Answers

Answer Posted / anand k

--Count of Columns
SELECT COUNT(*) NO_OF_COLUMNS
FROM SYS.COLUMNS
WHERE OBJECT_ID = OBJECT_ID('<TableName>')
ORDER BY Column_ID

--Column Names
SELECT [NAME]
FROM SYS.COLUMNS
WHERE OBJECT_ID = OBJECT_ID('<TableName>')
ORDER BY Column_ID

Is This Answer Correct ?

14 Yes

6 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain the difference between control flow and data flow?

1054

how you can deploy an ssrs report?

185

How do I find the sql server database version?

1051

What is 1nf 2nf and 3nf?

953

Can we take the full database backup in log shipping?

993

What is cached report?

150

What is a result set object returned by odbc_exec()?

1075

How to maintain a fill factor in existing indexes?

1049

How to install sql server 2005 express edition?

1166

What stored by the master?

1010

can a table be moved to different filegroup? : Sql server administration

1018

Does partitioning improve performance sql server?

1023

What language is sql server written in?

1079

What is the cpu pressure?

1107

Define normalisation?

1155