SQL

How to View column names of a table in SQL

DESCRIBE Table_Name;

OR 

DESC Table_Name;

show column from sql server

select *
from INFORMATION_SCHEMA.COLUMNS
where TABLE_NAME='tableName'

show column names in sql table

-- sql server 
sp_columns feeAgreement
-- or
SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = N'feeAgreement'

get table column names sql

SELECT      COLUMN_NAME AS 'ColumnName'
FROM        INFORMATION_SCHEMA.COLUMNS 
WHERE 
TABLE_NAME LIKE '%assembly_armatureassy_tbl%' 
and COLUMN_NAME LIKE '%supplied%'

get column name list sql

EXEC sp_columns 'Your Table Name'