Subject | Re: How to update table structure with SQL? |
---|---|
Author | neighbour.kerry |
Post date | 2009-06-23T06:47:05Z |
--- In firebird-support@yahoogroups.com, "neighbour.kerry" <kerry@...> wrote:
After a bit of searching in this forum, I may have come up with an alternative.
- Rename the existing DB
- Create a new DB with the updated DDL script
- data pump all the data across from the original database
Mind you, I still have to write the data pump, but that looks like it might be easier that trying to get the CREATE/ALTER stuff to work.