Last answered:

12 Jun 2023

Posted on:

11 Jun 2023

0

DELETE Triger on DB or stored Triger on Table?

Hello, Thank you so much for this. I have question might be easy and cleare but I have dought can how can we delete Trigger? Or for how long Trigger will be saved on our  DB ?  Another question is the stored Trigger apllied for one database? For example the one created will be only stored on employees DB? How about if we have another DS with the same Table that has Trigger?

1 answers ( 0 marked as helpful)
Instructor
Posted on:

12 Jun 2023

0

Hi Snoor!
Thanks for reaching out.


You can go to the info icon of the database and click on Triggers. Then, you can use the trigger and remove it. A trigger is used only for the particular table you've applied to. You have to specify the database name and the table.



Hope this helps.
Best,
Tsvetelin

Submit an answer