Condividi tramite

Modifying Triggers

  • Articolo

You can modify triggers through the Table Designer or through the language.

To modify a trigger

  • In the Table tab of the Table Designer, enter the new trigger expression in the Insert trigger, Update trigger, or Delete trigger box.

    -or-

  • Issue the SET SAFETY OFF command, and then use the CREATE TRIGGER command.

When you modify a trigger by first issuing the SET SAFETY OFF command and then re-creating the trigger, the old trigger expression is automatically deleted and replaced by the re-created trigger expression.

Using Triggers to Build Referential Integrity

Visual FoxPro provides a Referential Integrity Builder to generate triggers and stored procedures that will enforce Referential Integrity (RI) for your database. For more information on using the RI Builder, see Creating Databases.

See Also

Removing or Deleting Triggers | Modifying the Table Structure | Working with Tables | Creating Triggers | Trigger Usage