Sybase CREATE Trigger

Triggers can be automatically manipulated. The trigger works as long as the data is modified (whether it's data entry or action by the application). Triggers are designed for one or more data modification operations (update, insert, and delete) and are executed once for each SQL statement.

The following creates a trigger for a history_record_bak table

Create TRIGGER T1
On History_record_bak
For INSERT, UPDATE, delete
As
Print "Now modify the History_record_bak!!!!!!!!!!!!!!!!!!!!!!!!!!"
Go

When you do an INSERT, UPDATE, delete operation on this table, you will be prompted with "now modify the History_record_bakthe!!!!!!!!!!!!!!!!!!!!!!!!!!" and of course this sentence, You can change the operation to another table.

Sybase CREATE Trigger