In TDM, there is no configuration to define values standard for suffixes and prefixes of triggers and store procedures, and others configurations with Foreign Keys.
TDM users can write patterns for triggers, stored procedures and views. Open the Text Objects dialog (CTRL+T), select Settings | Patterns to open the Patterns dialog. Whatever you write into the Trigger pattern tab will be used whenever you create a new trigger. In patters, you can also use the following internal macros:
%tmplNow% - time stamp
%tmplDate% - date
%tmplTime% - time
%tmplTriggerName% - trigger name
%tmplTableName% - table name (for triggers only)
%tmplProcedureName% - stored procedure name
%tmplViewName% - view name
So, if the end-user wishes to write a prefix or suffix for his trigger, he can write something similar to the Trigger Patterns tab:
Create Trigger tri_%tmplTableName%
for %tmplTableName% after insert as
....
....
(code for Firebird)
For more information please see the TDM2 online help, section Entity Relationship Diagram | Creating a Trigger.
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center