Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
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|