English 中文(简体)
SAP HANA Tutorial

SAP HANA Introduction

SAP HANA Modeling

SAP HANA Reporting

SAP HANA Security

SAP HANA Data Replication

SAP HANA Monitoring

SAP HANA SQL

SAP HANA Useful Resources

Selected Reading

SAP HANA - SQL Triggers
  • 时间:2024-06-22

SAP HANA - SQL Triggers


Previous Page Next Page  

Triggers are stored programs, which are automatically executed or fired when some events occur. Triggers are, in fact, written to be executed in response to any of the following events −

    A database manipulation (DML) statement (DELETE, INSERT, or UPDATE).

    A database definition (DDL) statement (CREATE, ALTER, or DROP).

    A database operation (SERVERERROR, LOGON, LOGOFF, STARTUP, or SHUTDOWN).

Triggers could be defined on the table, view, schema, or database with which the event is associated.

Benefits of Triggers

Triggers can be written for the following purposes −

    Generating some derived column values automatically

    Enforcing referential integrity

    Event logging and storing information on table access

    Auditing

    Synchronous reppcation of tables

    Imposing security authorizations

    Preventing invapd transactions

Advertisements