Chapter 15 System Tables
1025
SYSPROCEDURE system table
Column name Column type
Column
constraint
Table constraints
proc_id UNSIGNED INT NOT NULL Primary key
creator UNSIGNED INT NOT NULL Unique index. Foreign
key references
SYSUSERPERM.user
_id
proc_name CHAR(128) NOT NULL
proc_defn LONG
VARCHAR
remarks LONG
VARCHAR
replicate CHAR(1) NOT NULL
srvid INTEGER Foreign key references
SYSSERVERS
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.
srvid If a procedure on a remote database server, indicates the remote
server.
To Next Page
Loading...