Skip to content
← dbForge Studio for SQL Server

How can we improve the product?

dbForge Studio for SQL Server: Features

Categories

JUMP TO ANOTHER FORUM

(thinking…)

Existence logic needed for triggers

When a new trigger is created, the script tests for existence first. So if the trigger does not exist, it will not create it. It should not test for existence as it will never create the trigger. It's unnecessary to check the object's existence if the product is using CREATE OR ALTER trigger.

1 vote
Vote

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
You have left! (?) (thinking…)
Garry shared this idea  ·   ·  Report…  ·  Admin →
How important is this to you?

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • Support Team commented  ·   ·  Report

    Hi,

    Thank you for reaching out to us!

    Kindly be informed that in particular, in Generate Script for the database, there is an option 'Check for object existence'. It will add this check before creating the trigger:

    IF OBJECT_ID(N'dbo.trigger1', 'TR') IS NULL ... CREATE...

    Could you please clarify, what functionality you mean? Where should be added the check?

    Best regards,
    Devart Support Team