Interbase Trigger Prefixes

[Simon_K]

Having a problem outputting DDL scripts containing autoinc fields in interbase. these generate triggers and procedures in the DDL script.

However if the suffix for each trigger / procedure tends to be the full table name, something like

<MyLongTableName>_<MyLongTableName>ID_Inc

Unfortunatley this generates errors in interbase as the trigger name is just too long.

Is there anyway to change this suffix to just ID_Inc, and exclude the table name again?  It means we've had to go through the entire DB structure and rename all our table names so the Triggers created have short  enough names.


Any help would save us so much time. Anyone help?

Thanks

[thomaskilian]

You might either run a transformation of your own to shorten the name or you have to write a DDL code generation as has been suggested earlier on this board (you have to do a search).