Sqlite Dynamic trigger lifecycle -

I want to create dynamic triggers in Java Before performing the insert / delete / update, I will prepare the trigger with the correct data which has to be done when the insert / delete / update ends and the trigger is left.

Is it OK to drop and the resume runs dynamically through the application? If so, what is the risk?

You can dynamically create triggers but I do not know why you If your calling application is fully aware of how data needs to be compromised, then why not make your calling application database updates?

Triggers occur when you always want to do something with your data, every time data is updated, inserted or deleted. It is not what you want that you are trying to run a statement only once, in your application it is better to do this.