• Home
• us.fatehi
• schemacrawler-hana
• 16.23.2
• source code
• TRIGGERS.sql

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

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

SELECT
  NULL AS TRIGGER_CATALOG,
  TRIGGERS.SCHEMA_NAME AS TRIGGER_SCHEMA,
  TRIGGERS.TRIGGER_NAME AS TRIGGER_NAME,
  TRIGGERS.TRIGGER_EVENT AS EVENT_MANIPULATION,
  NULL AS EVENT_OBJECT_CATALOG,
  TRIGGERS.SUBJECT_TABLE_SCHEMA AS EVENT_OBJECT_SCHEMA,
  TRIGGERS.SUBJECT_TABLE_NAME AS EVENT_OBJECT_TABLE,
  0 AS ACTION_ORDER,
  '' AS ACTION_CONDITION,
  TRIGGERS.TRIGGERED_ACTION_LEVEL AS ACTION_ORIENTATION,
  TRIGGERS.TRIGGER_ACTION_TIME AS CONDITION_TIMING,
  '' AS ACTION_STATEMENT,
  NULL AS ACTION_REFERENCE_OLD_TABLE,
  NULL AS ACTION_REFERENCE_NEW_TABLE,
  NULL AS ACTION_REFERENCE_OLD_ROW,
  NULL AS ACTION_REFERENCE_NEW_ROW,
  TRIGGERS.CREATE_TIME AS CREATED,
  TRIGGERS.IS_VALID,
  TRIGGERS.IS_ENABLED,
  TRIGGERS.CREATE_TIME,
  TRIGGERS.TRIGGER_OID,
  TRIGGERS.OWNER_OID,
  TRIGGERS.DEFINITION 
FROM
  SYS.TRIGGERS