SQL Query to get Field names as Records

    At times you may need to have the SQL table column names in runtime for your various reasons, below is the simple query to get the columns as records for any given table. Copy the below code and execute in your SQL Query window.
select column_name,* from information_schema.columns  
where table_name = 'Your Table Name'
order by ordinal_position

For More tips on SQL query... keep comeback to this blog