How to get list of filed names in Sql table

Below code show you how to get list of field names in selected SQL database table.

SQL Code

SELECT  Table_Name, Column_Name

FROM information_schema.Columns

WHERE Table_Name = '<TableName>'

ORDER BY Table_Name, Ordinal_Position

Try it copy & Paste on SQL Query  analyzer  edit with your <TableName> 

Code Description

1. FROM information_schema.Columns             -  Table name in SQL master table

2. Select Table_Name, Column_Name               -  Field name in Information Table

3. WHERE Table_Name = '<TableName>'          -  Find your table name
4. ORDER BY Table_Name, Ordinal_Position   - Order Field by Table name and original field order