My current data modeler is Erwin and I’m evaluating Toad Data Modeler.
I’d like to know if it is possible to generate triggers from the relationships instead of creating foreign key constraints.
For example, if I define a relationship with cascade delete between my_table and my_table_2, I’d like to have an auto-generated trigger such as:
create trigger [dbo].[tD_my_table] on [dbo].[my_table] for DELETE as
my_table_2.fk_my_table_pk = deleted.my_table_pk