To get details about the columns of a table, you can execute the sp_columns stored procedure.

Its syntax is:

sp_columns [ @table_name = ] object [ , [ @table_owner = ] owner ]

[ , [ @table_qualifier = ] qualifier ]

[ , [ @column_name = ] column ]

[ , [ @ODBCVer = ] ODBCVer ]

This procedure can take many arguments but one is required. The required argument is the name of the

USE NORTHWND
GO
 sp_columns N'Employees'