SqlTrigger

SQL Trigger

This app allows you to maintain DML triggers for your workspace dataBase tables.

In the main editor window you can edit the body of the trigger. The Create/Alter ,trigger name and table name must be omitted. After saving the trigger it will be checked for errors. If no Errors are found it will be added to your DataBase.

It is always good practice to add a brief description for your trigger. The description is searchable within the trigger list.

Example Usages

Only write the body of the trigger! Is this case the CREATE Trigger ExampleTrigger ON ExampleTable is automatictly generated.

after UPDATE   
AS RAISERROR ('Update on ExampleTable', 15, 1);