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

SYSPROCS consolidated view Next Page

SYSPROCPARMS consolidated view


Each row in the SYSPROCPARMS view describes a parameter to a procedure in the database.

The tables and columns that make up this view are provided in the SQL statement below. To learn more about a particular table or column, use the links provided beneath the view definition.

ALTER VIEW "SYS"."SYSPROCPARMS"( creator,
  procname,parmname,parm_id,parmtype,parmmode,parmdomain,
  length,scale,"default",user_type) 
  as select up.user_name,p.proc_name,pp.parm_name,
      pp.parm_id,pp.parm_type,
    if pp.parm_mode_in = 'Y' and pp.parm_mode_out = 'N' 
     then 'IN' else
     if pp.parm_mode_in = 'N' and pp.parm_mode_out = 'Y' 
      then 'OUT' else 'INOUT' 
     endif
    endif,
    dom.domain_name,pp.width,pp.scale,pp."default",
    ut.type_name from
    SYS.SYSPROCPARM as pp join
    SYS.SYSPROCEDURE as p on p.proc_id = pp.proc_id join
    SYS.ISYSUSER as up on up.user_id = p.creator join
    SYS.SYSDOMAIN as dom on dom.domain_id = pp.domain_id left outer join
    SYS.SYSUSERTYPE as ut on ut.type_id = pp.user_type
See also