| Subject | Altering an existing table with generator/triggers |
|---|---|
| Author | Peter Bailey |
| Post date | 2010-06-07T04:15:33Z |
Hi List
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.
TIA
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.
TIA
Peter