The SYSPROCS view shows the procedure or function name, the name of its creator and any comments recorded for the procedure or function.
The tables and columns that make up this view are provided in the ALTER VIEW statement below.
ALTER VIEW "SYS"."SYSPROCS"( creator, procname,remarks ) as select u.user_name,p.proc_name,r.remarks from SYS.ISYSPROCEDURE as p join SYS.ISYSUSER as u on u.user_id = p.creator left outer join SYS.ISYSREMARK as r on(p.object_id = r.object_id); |
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |