desc columns in mssql server

MSSQL syntax

exec sp_columns <table_name>;

Example

exec sp_columns employee_details;

Output::

It will show the table_name, column_name etc information.