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);
|Envoyer votre avis sur cette page par email.||Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1|