Skip to content

inspectTrigger ​

Command: inspectTrigger
Category: Object Inspection
Status: Production Ready

Description ​

Return metadata about a Trigger

Syntax ​

bash
hana-cli inspectTrigger [schema] [trigger] [options]

Aliases ​

  • itrig
  • trigger
  • insTrig
  • inspecttrigger
  • inspectrigger

Command Diagram ​

Parameters ​

Positional Arguments ​

ParameterTypeDescription
schemastringTarget schema (optional positional input).
triggerstringTrigger name (optional positional input).

Options ​

OptionAliasTypeDefaultDescription
--trigger-tstring*Trigger name to inspect.
--schema-sstring**CURRENT_SCHEMA**Schema that contains the trigger.
--output-ostringtblOutput format. Choices: tbl, sql.

Examples ​

Basic Usage ​

bash
hana-cli inspectTrigger --trigger myTrigger --schema MYSCHEMA

Execute the command

SQL Definition Output ​

bash
hana-cli inspectTrigger --trigger myTrigger --schema MYSCHEMA --output sql

Display the trigger definition in SQL format.

See Also ​