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 | 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) | Indicates whether the procedure is a primary data source in a Replication Server installation. |
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. |
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)
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |