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.