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 » Consolidated views

SYSPROCAUTH consolidated view Next Page

SYSPROCS consolidated view

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.

  as select u.user_name,p.proc_name,p.remarks from
    SYS.SYSPROCEDURE as p join
    SYS.ISYSUSER as u on u.user_id = p.creator