how to make SQL show columns selected with column headers code example

Example 1: get column name sql server

SELECT *
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = N'Customers'

Example 2: How to View column names of a table in SQL

DESCRIBE Table_Name;

OR 

DESC Table_Name;