Each row in the SYSPROCEDURE system view describes one procedure in the database. The underlying system table for this view is ISYSPROCEDURE.
|Column name||Column type||Column constraint|
|proc_id||UNSIGNED INT||NOT NULL|
|creator||UNSIGNED INT||NOT NULL|
|object_id||UNSIGNED BIGINT||NOT NULL|
proc_id Each procedure is assigned a unique number (the procedure number).
creator The owner of the procedure.
object_id The internal ID for the procedure, uniquely identifying it in the database.
proc_name The name of the procedure. One creator cannot have two procedures with the same name.
proc_defn The definition of the procedure.
remarks Remarks about the procedure. This value is stored in the ISYSREMARK system table.
replicate (Y/N) Indicates whether the procedure is a primary data source in a Replication Server installation.
srvid If the procedure is a proxy for a procedure on a remote database server, indicates the remote server.
source The preserved source for the procedure. This value is stored in the ISYSSOURCE system table.
avg_num_rows Information collected for use in query optimization when the procedure appears in the FROM clause.
avg_cost Information collected for use in query optimization when the procedure appears in the FROM clause.
stats Information collected for use in query optimization when the procedure appears in the FROM clause.
PRIMARY KEY (proc_id)
FOREIGN KEY (srvid) references SYS.ISYSSERVER (srvid)
FOREIGN KEY (object_id) references SYS.ISYSOBJECT (object_id) MATCH UNIQUE FULL
FOREIGN KEY (creator) references SYS.ISYSUSER (user_id)
UNIQUE (proc_name, creator)