Re: Copy table

Posted in 1997

Bill Ennis — 21 Jan 1997 13:23:09 -0500 — source: Informix-list mailing list archive (1991-1998)

Hi, Assuming that your databases belong to the same database instance you can run the following SQL command: INSERT INTO <db2>:tableA SELECT * FROM <db1>:tableA where: db2 is the destination database db1 is the source database -Bill > > Hi all, > > I'd like to know how do I do to copy one table from one database to > another database (database has a different name, but not the table). > > I cannot drop the target database, because it already has some tables. > > Thanks in advance > > Stephane > > -- Bill Ennis Voice: 312-474-7516 SSA Fax: 312-474-7460 500 W. Madison email: ennis@ssax.com