Re: how to copy tables between databases

Lijun Feng wrote: > Hi Experts, > > I'm new to Informix. Here is one question: > > We have a database which has 10 tables including hundreds records. We > want to transfer or copy 6 of the 10 tables to another database, we want > to keep both table structure and records. Is there any easy way to do > this? In DBAccess? > > Thanks in advance. > > Lijun > -- > _/_/_/_/_/_/_/_/_/_/ Department of Computer & Information Science > _/ Lijun Feng _/ The Ohio State University > _/_/_/_/_/_/_/_/_/_/ Columbus, OH 43210 Take a lookt athe sql statement CREATE SYNONYM. I think you'll find this is the easiest solution ( and probably the best !) Regards David -- David Thompson (+44171 721 6808) Salomon Smith Barney (London) Email : mailto:david.thompson@ssmb.com Internet : http://www.smithbarney.com