SYSPROCEDURECOLUMNS

From Recital Documentation Wiki
Revision as of 16:02, 13 March 2009 by Yvonnemilne (Talk | contribs)

Jump to: navigation, search

SYSPROCEDURECOLUMNS

Class

SQL Applications


Purpose

Description of the input, output and results associated with certain stored procedures available


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
COLUMN_NAME C 30 Column/parameter name
COLUMN_TYPE N 1 Kind of column/parameter
DATA_TYPE N 2 SQL data type
TYPE_NAME C 30 SQL type name
PRECISION N 2 Precision
LENGTH N 4 Length in bytes of data
SCALE N 2 Scale
RADIX N 1 Radix
NULLABLE N 1 Can it contain NULL
REMARKS C 30 Comment describing parameter/column


Example

EXEC SQL
SELECT *
FROM sysprocedurecolumns;


Products

Recital Database Server, Recital Mirage Server, Recital Terminal Developer