SOURCE_DEFINITION
Records source definitions for defaults, check constraints, views, modules, procedures, functions and triggers.
Column name
|
Data type
|
Description
|
SOURCE_SYSID
|
INTEGER
|
System identifier of the source definition. |
COLUMN_NAME
|
VARCHAR(128)
|
Column name if the source types is a default value for a column. |
SOURCE_TYPE
|
CHAR(20)
|
One of:
"DEFAULT"
"CHECK"
"VIEW"
"MODULE"
"PROCEDURE"
"FUNCTION"
"TRIGGER". |
SEQUENCE_NO
|
INTEGER
|
Sequence number in source definition. |
SOURCE_LENGTH
|
INTEGER
|
The length of the stored source text. |
SOURCE_DEFINITION
|
VARCHAR(5000)
|
The stored source text. |
Primary key: SOURCE_SYSID, COLUMN_NAME, SEQUENCE_NO
