mysql.information_schema.TRIGGERS.sql Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of schemacrawler-mysql Show documentation

There is a newer version: 16.22.3

SELECT
  TRIGGER_SCHEMA AS TRIGGER_CATALOG,
  NULL AS TRIGGER_SCHEMA,
  TRIGGER_NAME,
  EVENT_MANIPULATION,
  EVENT_OBJECT_CATALOG,
  EVENT_OBJECT_SCHEMA,
  EVENT_OBJECT_TABLE,
  ACTION_ORDER,
  ACTION_CONDITION,
  ACTION_STATEMENT,
  ACTION_ORIENTATION,
  ACTION_TIMING,
  ACTION_REFERENCE_OLD_TABLE,
  ACTION_REFERENCE_NEW_TABLE,
  ACTION_REFERENCE_OLD_ROW,
  ACTION_REFERENCE_NEW_ROW,
  CREATED,
  SQL_MODE,
  DEFINER,
  CHARACTER_SET_CLIENT,
  COLLATION_CONNECTION,
  DATABASE_COLLATION
FROM
  INFORMATION_SCHEMA.TRIGGERS