get the columns of a table sql server code example

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

DESCRIBE Table_Name;

OR 

DESC Table_Name;