Sp_help - TSQL Tutorial

On Transact SQL language the sp_help is part of Database Engine Stored Procedures and reports information about a database object or a data type.

Sp_help syntax:

sp_help [ @objname = 'Object name.' ] ;


Sp_help example 1:

USE model;
GO
EXEC sp_help;
GO

Sp_help example 2:

USE model;
GO
EXEC sp_help 'students';
GO