Try Opteryx

SHOW TRIGGERS FOR

The SHOW TRIGGERS FOR statement lists the triggers attached to a table — the refresh triggers created by CREATE MATERIALIZED VIEW, showing which materialized views a commit to this table will refresh, and how the most recent firing went.

Syntax

SHOW TRIGGERS FOR <table_name>;

Bare SHOW TRIGGERS is not supported — name the table with the FOR form, or query information_schema.triggers for a workspace-wide listing:

SELECT * FROM my_workspace.information_schema.triggers;

Parameters

  • <table_name> — fully qualified as <workspace>.<collection>.<table_name>.

Result Columns

The columns returned are those of information_schema.triggers, including target_view, last_fired_at, and last_fired_status — the place to look when a materialized view seems stale.

Examples

List Triggers on a Table

SHOW TRIGGERS FOR my_workspace.sales.orders;

Notes

  • Trigger names are auto-generated as refresh__<collection>__<view_name>__<suffix>.
  • Remove a listed trigger with DROP TRIGGER.

See Also