Subject Re: [firebird-support] Altering an existing table with generator/triggers
Author Martijn Tonies
Hello Peter,

> Using Firebird-, (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

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

Database questions? Check the forum: