Generating Triggers and Procedures

You can create or modify database triggers to a script or to a live database connection.

1. Select Database > Generate Database to open the Database Generation window, and specify the standard options, including whether you want to generate to a script or to a live database connection.

   For detailed information about using this window, see the Generating a Database from a PDM.

2. Select "Triggers & Procedures (with Permissions)" from the Settings set list in the Quick Launch groupbox at the bottom of the window. This settings set specifies standard options for generating triggers and procedures.

   or:

   Click the Options tab and click on Trigger in the left-hand pane to display the trigger generation options. Change the default options as appropriate.

   For detailed information about settings sets, see Quick Launch Selection and Settings Sets.

3. [optional] Click the Selection tab and select the Table or Procedure subtab at the bottom of the tab. Select the tables or procedures that you want to generate for. Note that if you want to generate a trigger script for tables owned by a particular owner, you can select an owner from the Owner list.
4. Click OK to begin the generation.

• Defining a Generation Order for Stored Procedures
  You can define the order of the generation of stored procedures by using traceability links with a type of DBCreateAfter. The procedure from which you start the traceability link is dependent on the procedure you link it to, and this influent procedure will be generated before the dependent procedure.
• Creating User-Defined Error Messages
  You can create a message table in your database to store user-defined error messages. When you select trigger generation parameters, you can choose to generate an error message from this table.