Database Triggers and Logging Tables

What:  Database Triggers are automatically executed or fired when some event occurs.

• 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 SHUTDOW

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

Benefits of Triggers:

• Generating some derived column values automatically
• Enforcing referential integrity
• Event logging and storing information on table access
• Auditing
• Synchronous replication of tables
• Imposing security authorizations
• Preventing invalid transactions

http://www.sapstudent.com/hana/sap-hana-reporting-connectivity-options/2

http://www.guru99.com/sap-hana-sql.html


Logging tables:  table logs are saved in the DBTABLOG.