Difference between revisions of "SYSPROCEDURECOLUMNS"
From Recital Documentation Wiki
Yvonnemilne (Talk | contribs) |
Helengeorge (Talk | contribs) |
||
| Line 1: | Line 1: | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
==Purpose== | ==Purpose== | ||
Description of the input, output and results associated with certain stored procedures available | Description of the input, output and results associated with certain stored procedures available | ||
Revision as of 15:29, 29 October 2009
Contents
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
