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);
|Send feedback about this page via email or DocCommentXchange||Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0|