Creating an ASE Trigger

Under an ASE connection profile in Database Explorer, expand the Tables folder.

Select a table on which you want to create the trigger and right-click on it. Select New|Trigger to invoke the Create Trigger Skeleton wizard.

In the Name field, enter a name for the trigger.

Select the type of SQL statement (update, insert, or delete) that is to fire the trigger.

Add any description to the trigger in the Comments field.

Click Finish.

The trigger skeleton appears in SQL Editor and is created in the database. You can now proceed to edit the SQL code.