Returning only the column names from a SELECT statement

Question

This is just a lazy thought. I have a table with about 9 columns names. Is there any way I can use SQL statement to return only the Column names? The normal way is to write out my column names from

SELECT * FROM tableName;

statement but was wondering if I can get the column names with SQL statement.

Any Ideas would be appreciated.

Thanks You!

What DBMS are you using? If it is SQL Server I would be inclined to use the system views (e.g. sys.columns) rather than the information schema for reasons outlined in this article by Aaron Bertrand — GarethD
– GarethD, Commented Dec 31, 2013 at 11:11
Hi Bro, this statements would be used via the code behind file in an ASP.NET application. I need to get the result set then parse the returned values to a dropDownList control which will then be used for further quesries. So in a nutshell...would be using SQL Server when the application is finally deployed to the life Server. — Guzzyman
– Guzzyman, Commented Dec 31, 2013 at 11:17
possible duplicate of How can I get column names from a table? — Ramesh Rajendran
– Ramesh Rajendran, Commented Dec 31, 2013 at 11:27

MichaC · Accepted Answer · 2013-12-31 11:08:39Z

5

SELECT COLUMN_NAME,* 
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = 'tableName' AND TABLE_SCHEMA='dbo'

Should do it

answered Dec 31, 2013 at 11:08

MichaC

13.7k2 gold badges49 silver badges57 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Sandip Bantawa · Accepted Answer · 2013-12-31 11:18:03Z

1

SET FMTONLY ON
SELECT * FROM tablename

answered Dec 31, 2013 at 11:18

Sandip Bantawa

2,9004 gold badges35 silver badges48 bronze badges

Comments

शेखर · Accepted Answer · 2013-12-31 11:20:48Z

0

Open you Microsoft SQL Server Management Studio, in New Query, Just type your Table name and select it and then press ALT + F1 Key, it will give all details about table

edited Dec 31, 2013 at 11:20

शेखर

17.6k14 gold badges64 silver badges123 bronze badges

answered Dec 31, 2013 at 11:11

Manoj Mevada

6694 silver badges7 bronze badges

Comments

Community · Accepted Answer · 2017-05-23 11:51:34Z

0

You can query the syscolumns table for table column metadata.

 SELECT [name] AS [Column Name]
FROM syscolumns
WHERE id = (SELECT id FROM sysobjects WHERE  [Name] = 'TableName')

See this image that query return values

enter image description here

Referred from : How can I get column names from a table in Oracle?

and another one way

edited May 23, 2017 at 11:51

CommunityBot

11 silver badge

answered Dec 31, 2013 at 11:24

Ramesh Rajendran

38.9k49 gold badges159 silver badges241 bronze badges

1 Comment

Guzzyman Over a year ago

Thanks, I tried this method alongside with the others in the answers to my question but I got only the COLUMN NAME header as my result. So decided to use a datatable to get the result of the normal sql SELECT * FROM tableName statement, binded it to a gridView, used the HeaderRow.Count property of the GridView to get the HeaderNames, passed same into a DataTable, then Populated my Drop Down List Control with the results.

Karan Kular · Accepted Answer · 2013-12-31 14:18:12Z

0

select column_name,* from information_schema.columns where table_name = 'YourTableName' order by ordinal_position

answered Dec 31, 2013 at 14:18

Karan Kular

91 bronze badge

Comments

Teemu Lehto · Accepted Answer · 2014-11-08 20:32:28Z

0

Using SQL Server xml raw you get the column names from any sql query. Replace 'select top 1 * from [TABLENAME]' from the example below. Query must return at least 1 row of data and remember to use top 1.

declare @t1 table (x xml)
declare @t2 table (x xml)
declare @t3 table (x xml)

insert into @t1 select cast( (select top 1 * from [TABLENAME] for xml raw) as xml)
insert into @t2 select y.r.query('.') from @t1 cross apply x.nodes('/row') as y(r)
insert into @t3 select t2.n.value('local-name(.)', 'varchar(max)') from @t2 t cross apply x.nodes('//@*') as t2(n)

select replace (convert (nvarchar, x),'_x0020_', ' ') from @t3

answered Nov 8, 2014 at 20:32

Teemu Lehto

1

Comments

Sandip Bantawa · Accepted Answer · 2019-12-16 11:36:58Z

0

Try following SQL statement to get column name.

SELECT column_name   
FROM information_schema.columns 
WHERE TABLE_NAME='tableName'

edited Dec 16, 2019 at 11:36

Sandip Bantawa

2,9004 gold badges35 silver badges48 bronze badges

answered Dec 31, 2013 at 11:14

Sagar Rawal

1,4422 gold badges12 silver badges41 bronze badges

Collectives™ on Stack Overflow

Returning only the column names from a SELECT statement

7 Answers 7

Comments

Comments

Comments

1 Comment

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

7 Answers 7

Comments

Comments

Comments

1 Comment

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related