Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Reference » Views » System views in Sybase Central

SYSPHYSIDX system view Next Page

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.

Columns
Column name Column type Column constraint
proc_id UNSIGNED INT NOT NULL
creator UNSIGNED INT NOT NULL
object_idUNSIGNED BIGINT NOT NULL
proc_name CHAR(128) NOT NULL
proc_defn LONG VARCHAR
remarks LONG VARCHAR
replicate CHAR(1) NOT NULL
srvid UNSIGNED INT
source LONG VARCHAR
avg_num_rowsFLOAT
avg_costFLOAT
statsLONG BINARY

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.

Constraints on underlying system table

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)