Trigger script lacks "OR REPLACE"

Toad for Oracle
1

All our triggers are typically written with 'CREATE OR REPLACE ' syntax. When you view the Script tab on a table, with the "Create or Replace" checkbox turned on, that is what you will see for all triggers. But, the Triggers tab has different behavior. It only shows 'CREATE ' in version 17.0.341.1977. It was 'CREATE OR REPLACE' in at least version 16.2. Is there a setting to correct this back to 'CREATE OR REPLACE'?

2

This is fixed in the current beta and will be fixed for Toad version 17.1

You can get the beta here if you want.

1 Like