Difference between revisions of "SYSPROCEDURECOLUMNS"
From Lianjapedia
Yvonne.milne (Talk | contribs) m (1 revision: SQL) |
Helen.george (Talk | contribs) |
||
| (2 intermediate revisions by the same user not shown) | |||
| 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 | ||
| − | |||
==See Also== | ==See Also== | ||
[[SQL Data Types|DATA TYPES]], [[SQL SELECT|SELECT]], [[SQL System Tables|SYSTEM TABLES]] | [[SQL Data Types|DATA TYPES]], [[SQL SELECT|SELECT]], [[SQL System Tables|SYSTEM TABLES]] | ||
| − | |||
==Description== | ==Description== | ||
System Tables are system defined read-only tables. You can query these tables using the SELECT statement. | System Tables are system defined read-only tables. You can query these tables using the SELECT statement. | ||
| − | + | {| class="wikitable" width="100%" | |
| − | {| class="wikitable" | + | |
!Column||Data Type||Width||Description | !Column||Data Type||Width||Description | ||
|- | |- | ||
| Line 38: | Line 35: | ||
|NULLABLE||N||1||Can it contain NULL | |NULLABLE||N||1||Can it contain NULL | ||
|- | |- | ||
| − | |REMARKS||C||30||Comment describing parameter/column | + | |valign="top"|REMARKS||valign="top"|C||valign="top"|30||Comment describing parameter/column |
|- | |- | ||
|} | |} | ||
| − | |||
==Example== | ==Example== | ||
| Line 48: | Line 44: | ||
</code> | </code> | ||
| − | |||
| − | |||
| − | |||
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:SQL]] | [[Category:SQL]] | ||
[[Category:System Tables]] | [[Category:System Tables]] | ||
Latest revision as of 10:45, 31 January 2013
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
SELECT * FROM sysprocedurecolumns
