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'