Skip to content

triggers ​

Command: triggers
Category: Object Inspection
Status: Production Ready

Description ​

List of all triggers

Syntax ​

bash
hana-cli triggers [schema] [trigger] [target] [options]

Aliases ​

  • trig
  • listTriggers
  • ListTrigs
  • listtrigs
  • Listtrig
  • listrig

Command Diagram ​

Parameters ​

Positional Arguments ​

ParameterTypeDescription
schemastringSchema name filter (optional positional input).
triggerstringTrigger name filter (optional positional input).
targetstringTarget object name filter (optional positional input).

Options ​

OptionAliasTypeDefaultDescription
--trigger-t, --Triggerstring*Trigger name pattern to match.
--target--to, --Targetstring*Subject table/target name pattern to match.
--schema-sstring**CURRENT_SCHEMA**Schema name or pattern to match.
--limit-lnumber200Maximum number of rows returned.
--profile-pstring-Connection profile override.

For additional shared options from the common command builder, use hana-cli triggers --help.

Examples ​

Basic Usage ​

bash
hana-cli triggers --schema MYSCHEMA --trigger %

Execute the command

Include Target Filter ​

bash
hana-cli triggers --schema MYSCHEMA --trigger % --target SALES_%

Filter trigger list by subject target object.

See Also ​