SYSTRIGCOL Catalog Table for SQL Trigger

SYSTRIGCOL Catalog Table for SQL Trigger
SYSTRIGCOL Catalog Table for SQL Trigger, catalog view, ib catalog, sql trigger in as400,, sql trigger in ibmi, sql trigger, SYSTRIGCOL
SYSTRIGCOL Catalog Table for SQL Trigger

This article contains the SYSTRIGCOL catalog table used for SQL triggers.

SYSTRIGCOL

This view contains the specific information about each column either implicitly or explicitly referenced in the WHEN clause or the triggered SQL statements of a trigger.

Structure of SYSTRIGCOL


Column Name Description
TRIGGER_SCHEMA Name of the schema containing trigger
TRIGGER_NAME Name of the trigger.
TABLE_SCHEMA Schema name containing table or view
TABLE_NAME Name of the table or view containing column referred in trigger
COLUMN_NAME The column that is referenced in the trigger
OBJECT_TYPE Type of the object that contains the column referenced in the trigger
SYSTEM_TRIGGER_SCHEMA System schema name.
SYSTEM_TABLE_SCHEMA Schema name of the table or view that contains the column that is referenced in the trigger
SYSTEM_TABLE_NAME System table or view name that contains the column that is referenced in the trigger

Example

Select * from QSYS2.SYSTRIGCOL

Result


Related Post

Post a Comment

© AS400 and SQL Tricks. All rights reserved. Developed by Jago Desain