Trigger script lacks "OR REPLACE"

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'?

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