StoredProc


Description

Stored procedure definitions that catalog the database stored procedures available for system operations, reporting, and data processing workflows.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
pkSPID int identity 4 null
ActionInStoredProc .FKSPID FK__ActionInS__FKSPI__4ACDF4E0 R
FieldsInStoredProc.fkSPID FK_FieldsInStoredProc_StoredProc C

Primary key - StoredProc unique identifier for each record

SPName varchar 50 null

Procedure name - Name of the stored procedure

SPDesc varchar 200 null

Procedure description - Description of what the stored procedure does

Indexes

Constraint Name Type Sort Column(s)
PK_StoredProc Primary key Asc pkSPID

Relationships