Generating Table Trigger DDL Commands

Display the data description language SQL code for adding a trigger to a table in the database. The SQL code can be a useful reference and training tool.

Prerequisites

Database Version	Table Trigger Privileges
SAP Sybase IQ 15.3 and 15.4	None required.
SAP Sybase IQ 16.0	None required.

The SAP Sybase IQ resource is authenticated and running.

Task

In the Perspective Resources view, select the resource and select Resource > Administration Console.
In the left pane, select IQ Servers > Schema Objects > Tables.
Select Tables or Proxy Tables.
Select a table or proxy table from the right pane and either:
- Click the arrow to the right of the name and select Properties, or
- From the Administration Console menu bar, select Resource > Properties.
The Table or Proxy Table Properties view appears.
In the left pane, select Triggers.

Note: Triggers does not appear when the selected table is not a system store table.
Select one or more triggers from the right pane and click Generate DDL.

Note: Use Shift-click or Control-click to select multiple triggers.

The DDL view shows the SQL code used to add the selected triggers to the table in the database.