Re: Problems creating SYNONYM

Posted in 2000

Obnoxio The Clown — Mon, 27 Mar 2000 10:28:49 BST — source: Informix-list mailing list archive (1991-1998)

From: Guido Drahota <gdrahotaNOgdSPAM@arcormail.de.invalid> > >Here we have two databases on the same server. Lets say db1 >and db2. In db1 we have a table Table1. I want to create a >synonym for Table1 in db1 on db2. >I tried: CREATE SYNONYM syn1 FROM db1:Table1 but this doesnt >work - syntax error. > >Can anybody help me? Yeah, sure. RTFM. CREATE SYNONYM syn1 FOR db1:Table1 Sheesh. Talk about lazy. ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com