1
Download General Reference - ALTIBASE Customer Support
Transcript
3.1 Meta Tables 3.1.44.2 See Also SYS_USERS_ SYS_TABLES_ 3.1.45 SYS_TRIGGER_DML_TABLES_ This meta table contains information about tables referenced by triggers. Column Data Type Description TABLE_ID INTEGER The table identifier TRIGGER_OID BIGINT The trigger identifier DML_TABLE_ID INTEGER The table identifier within the trigger STMT_TYPE INTEGER The type of executable statement 3.1.45.1 Column Information TABLE_ID This is the identifier of the table on which the trigger is defined, and corresponds to a TABLE_ID in the SYS_TABLES_ meta table. TRIGGER_OID This is the trigger identifier, and corresponds to a TRIGGER_OID in the SYS_TRIGGERS_ meta table. DML_TABLE_ID This is the identifier of the table that is accessed using the DML statements within the trigger, and corresponds to a TABLE_ID in the SYS_TABLES_ meta table. STMT_TYPE This is the type of statement executed on a table. • 8: DELETE • 19: INSERT • 33: UPDATE 3.1.45.2 See Also SYS_TABLES_ SYS_TRIGGERS_ 279 The Data Dictionary
