Hello Peter,

> Using Firebird-1.5.6.5026, (with Delphi 2007 and IBX components).
>
> Is there any way to alter the name of a table and its various references
> in the generator and triggers?
>
> My present understanding is that this cannot be done — "The Firebird
> Book", p661, states that the ALTER TRIGGER cannot be used to change the
> table with which the trigger is associated. This seems to rule it out.
>
> Is my only option to create a new table with associated generator and
> triggers, copy the data from the existing table and then to drop the
> existing table.

That is correct.

With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!

Database questions? Check the forum:
http://www.databasedevelopmentforum.com