Revision as of 16:02, 13 March 2009

SYSPROCEDURECOLUMNS

SQL Applications

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

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

EXEC SQL
SELECT *
FROM sysprocedurecolumns;

Recital Database Server, Recital Mirage Server, Recital Terminal Developer

Revision as of 12:10, 13 March 2009 (view source) Yvonnemilne (Talk \| contribs)		Revision as of 16:02, 13 March 2009 (view source) Yvonnemilne (Talk \| contribs) Newer edit →
Line 11:		Line 11:

	==See Also==		==See Also==
−	[[DATA TYPES]], [[SQL SELECT\|SELECT]], [[SYSTEM TABLES]]	+	[[SQL Data Types\|DATA TYPES]], [[SQL SELECT\|SELECT]], [[SQL System Tables\|SYSTEM TABLES]]