> I revert to this mailing list to ask for help accomplishing a specific
> I'll try to explain as best I can.
> Say I have a DB named... well... "database1", this db has the following
> What I want to do is copy each of the tables (exactly as they are,
> primary keys, data, etc) but at the same time change the prefix to
> else (ie: eng_) so that I would end up with:
> en_table1 (exact copy of pt_table1, including data PK, FK, etc..)
> en_table2 (exact copy of pt_table2, including data PK, FK, etc..)
> en_table3 (exact copy of pt_table3, including data PK, FK, etc..)
> Anyway of accomplishing this? Ideally without having to state each of the
> tables names. And also that this would work so that you could only
> tables that have a certain prefix, so: duplicate only tables that start
> "pt_" and change prefix to "es_" for example.
> Any help or point in the right direction will be much apreciated!
It seems you're trying to create something multi-lingual, would that
If so, why not design proper metadata so you don't have to copy
tables AND modify your queries.
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Database development questions? Check the forum!