Stored Procedure - SP_HELP

This stored procedure is used to display the description of a specific table.

Description means

A) Name of the Table

B) Columns contained by the Table

c) Data Types of the corresponding columns

D) Sizes of the Data Types.

Syntax:

SP_HELP TABLENAME

Example:

SP_HELP EMP

The above stored procedure displays the description of EMP table.

Stored Procedure - SP_HELP