Trigger Body Property Page

Top  Previous  Next

The Trigger's body can be defined in three different ways:

1.You can enter the SQL directly.  If you just want to enter the Trigger body's SQL directly, hit the Run Script toolbar button and type it in.

2.You can enter a VB Script that when evaluated will produce the Trigger Body's SQL.  Hit the Edit Script toolbar button and type it in.  If you are writing a Table Trigger, the VB Script can evaluate the Table's Relations to enforce referential constraints that are not implemented declaratively by the database.

3.Use the Script Type control to select a reusable Trigger Body VB Script that has been entered in the Script Explorer under Scripts->"database name"->Trigger Body.  A shortcut to this location has been provided on the Edit Script page.

 

The Trigger Body Property Page when the run button has been selected.

The Trigger Body Property Page when the run button has been selected.