SYSPROCEDURECOLUMNS

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, Recital Server