Get the number of columns from table

Question

0.00/5 (No votes)

See more:

SQL-Server-2008

Hi,

I have to find number of column from table and name of each column from that table.
please help me,how to find it?
Thanks.

Posted 2-Sep-11 3:02am

Pravinjas

Add a Solution

4 solutions

Add a Solution

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

Toniyo Jackson · Accepted Answer · 2011-09-02T03:07:00

Solution 3

This is to find the number of columns in a table.

SQL

SELECT COUNT(*) AS num_of_columns
FROM INFORMATION_SCHEMA.COLUMNS a
WHERE a.TABLE_NAME = 'tablename'

This is to get all the columns in a table.

SQL

SELECT COLUMN_NAME
FROM INFORMATION_SCHEMA.COLUMNS a
WHERE a.TABLE_NAME = 'tablename'

Posted 2-Sep-11 3:07am

Toniyo Jackson

Updated 2-Sep-11 3:12am

v3

Comments

Abhinav S 3-Sep-11 0:25am

Nice and precise. 5.

OriginalGriff · Accepted Answer · 2011-09-02T03:13:00

Solution 4

Try this SQL:

SQL

EXEC SP_Columns myTable

It will return a table with each column in a separate row. This gives you all the info you need!

Posted 2-Sep-11 3:13am

OriginalGriff

Comments

Abhinav S 3-Sep-11 0:26am

Good alternative.

Shameel · Accepted Answer · 2011-09-02T03:05:00

Solution 2

This query will do it for you:

SQL

SELECT * FROM sys.columns WHERE object_id = OBJECT_ID('dbo.Table1')

Posted 2-Sep-11 3:05am

Shameel

Comments

RaviRanjanKr 2-Sep-11 15:57pm

Nice Answer, its new to me, have a my 5+

Abhinav S · Accepted Answer · 2011-09-02T03:05:00

Solution 1

Check this out[^]. A slight modification to the query will give you a list of all columns.

Posted 2-Sep-11 3:05am

Abhinav S

Get the number of columns from table

4 solutions

Solution 3

Solution 4

Solution 2

Solution 1

Add your solution here

Preview 0

Get the number of columns from table

4 solutions

Solution 3

Solution 4

Solution 2

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us