SYSPROCEDURE system view

Each row in the SYSPROCEDURE system view describes one procedure in the database. The underlying system table for this view is ISYSPROCEDURE.

Column name Data type Description
proc_id UNSIGNED INT Each procedure is assigned a unique number (the procedure number).
creator UNSIGNED INT The owner of the procedure.
object_id UNSIGNED BIGINT The internal ID for the procedure, uniquely identifying it in the database.
proc_name CHAR(128) The name of the procedure. One creator cannot have two procedures with the same name.
proc_defn LONG VARCHAR The definition of the procedure.
remarks LONG VARCHAR Remarks about the procedure. This value is stored in the ISYSREMARK system table.
replicate CHAR(1) This property is for internal use only.
srvid UNSIGNED INT If the procedure is a proxy for a procedure on a remote database server, indicates the remote server.
source LONG VARCHAR The preserved source for the procedure. This value is stored in the ISYSSOURCE system table.
avg_num_rows FLOAT Information collected for use in query optimization when the procedure appears in the FROM clause.
avg_cost FLOAT Information collected for use in query optimization when the procedure appears in the FROM clause.
stats LONG BINARY Information collected for use in query optimization when the procedure appears in the FROM clause.
 Constraints on underlying system table
Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0