Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - SQL Usage » Stored procedures, triggers, batches, and user-defined functions » Triggers

 

Creating a trigger on a table (Sybase Central)

Create a trigger on a table by using the Create Trigger Wizard.

Prérequis

You must have the CREATE ANY TRIGGER or CREATE ANY OBJECT system privilege. Additionally, you must be the owner of the table the trigger is built on or have one of the following privileges:

  • ALTER privilege on the table
  • ALTER ANY TABLE system privilege
  • ALTER ANY OBJECT system privilege
 Task

  1. Use the SQL Anywhere 16 plug-in to connect to the database.

  2. In the left pane, right-click Triggers and click New » Trigger.

  3. Follow the instructions in the Create Trigger Wizard.

  4. To complete the code, in the right pane click the SQL tab.

Résultat

The new trigger is created.

 See also
Copyright © 2013, SAP AG ou société affiliée SAP - SAP Sybase SQL Anywhere 16.0