On Sunday, March 23, 2025, David G. Johnston <david.g.johns...@gmail.com>
wrote:

> On Sunday, March 23, 2025, Igor Korot <ikoro...@gmail.com> wrote:
>
>>
>> 2. Is there a way to do CREATE TRIGGER IF NOT EXIST for the earlier
>> version?
>>
>
> No.  You have to drop the trigger if it does exist and then create the new
> one.
>

Well, you can always query the catalogs directly to answer the question
“does this trigger exist”.

David J.

Reply via email to