disappearing triggers

PeterJ

Member
I keep loosing my triggers because I forget the DDL extracted for a table seems to include everything that is dropped when a table is dropped except for trigger definitions. Am I missing a plsqldev option or setting?
Otherwise can we have some options for the DDL created, in a future plsqldev release, such as whether or not to include associated bits such as triggers and grants, and including drop statements?
 
There is no option for this currently, but it's on the list of enhancement requests. Right now, if you recreate a table, you must make sure that triggers and foreign key references to the table are recreated as well.
 
Back
Top