1/*Get all columns from a table (sql server)*/
2SELECT *
3FROM INFORMATION_SCHEMA.COLUMNS
4WHERE TABLE_NAME = 'table name';
1/* To retreive the column names of table using sql */
2
3SELECT COLUMN_NAME.
4FROM INFORMATION_SCHEMA. COLUMNS.
5WHERE TABLE_NAME = 'Your Table Name'