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.|
Discuss this page in DocCommentXchange.
|Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0|