Deletion instruction at the beginning of SQL-DDL code for triggers (DROP TRIGGER)

Plug-in & Open API
, ,
1

Good evening ladies and gentlemen,

I’m a student and I’m currently finishing my bachelor’s work on the improvement of a plugin on VisualParadigm.

I’m writing to you to get some information because when I try to generate the SQL-DDL code of a trigger I always get this first line :

IF EXISTS (SELECT * FROM sys.triggers WHERE object_id = OBJECT_ID(N'test')) DROP TRIGGER test

While I have not indicated it anywhere in the plugin. So I deduced that it was VisualParadigm that integrated this line of code automatically when generating a trigger.

Does anyone know how to remove it?
It would be very useful for me.

For information, I generate SQL-DDL code for SQL Server databases.

I thank you and wish you all a good evening.

2

Hi ArberSmajli,

Thank you for your post. I have forwarded your question to our team to study. When there is an answer, I will let you know.

Best regards,
Jick Yeung