How to find count of columns of a table

Question

0.00/5 (No votes)

See more:

I know to take number of rows using select count(*) from tbl_name;
But How to find count of columns of a table

Posted 15-Oct-10 22:57pm

Updated 15-Oct-10 23:16pm

v2

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sandeep Mewara · Answer 1 · 2010-10-15T23:08:00

Try this:

SQL

SELECT count(*)
FROM information_schema.columns
WHERE table_name = '<table_name>'

Posted 15-Oct-10 23:08pm

Comments

Sandeep Mewara 16-Oct-10 5:09am

Just to add, not sure of it would work on SQL2000 or not. That's too old an version to confirm for me.