SYSPROCEDURES

From Recital Documentation Wiki
Revision as of 16:41, 9 December 2009 by Helengeorge (Talk | contribs)

Jump to: navigation, search

SYSPROCEDURES

Class

SQL Applications


Purpose

Description of the stored procedures available in the catalog


See Also

DATA TYPES, SELECT, SYSTEM TABLES


Description

System Tables are system defined read-only tables. You can query these tables using the SELECT statement.


Column Data Type Width Description
PROCEDURE_CAT C 100 Procedure catalog
PROCEDURE_SCHEM C 30 Procedure schema
PROCEDURE_NAME C 30 Procedure name
R1 L 1 Reserved
R2 L 1 Reserved
R3 L 1 Reserved
REMARKS C 30 Comment describing procedure
PROCEDURE_TYPE N 1 Kind of procedure


Example

EXEC SQL
SELECT *
FROM sysprocedures;


Products

Recital, Recital Server