Reference Manual
CHAPTER 15. System Tables
Column name |
Column type |
Column constraint |
Table constraints |
|---|---|---|---|
proc_id |
SMALLINT |
NOT NULL |
Primary key |
creator |
SMALLINT |
NOT NULL |
Foreign key references SYS.SYSUSERPERM. user_id |
proc_name |
CHAR(128) |
NOT NULL |
|
proc_defn |
LONG VARCHAR |
||
remarks |
LONG VARCHAR |
||
replicate |
CHAR(1) |
NOT NULL |
Each procedure in the database is described by one row in SYSPROCEDURE.
proc_id Each procedure is assigned a unique number (the procedure number), which is the primary key for SYSPROCEDURE.
creator This user number identifies the owner of the procedure. The name of the user can be found by looking in SYSUSERPERM.
proc_name The name of the procedure. One creator cannot have two procedures with the same name.
proc_defn The command that was used to create the procedure.
remarks A comment string.
replicate (Y/N) Indicates whether the procedure is a primary data source in a Replication Server installation.