Re: synonyms

Posted in 1998

Jonathan Leffler — Thu, 28 May 1998 23:35:33 -0700 — source: Informix-list mailing list archive (1991-1998)

Katrin Goericke wrote: > Paul wrote: > > I have created severl synonyms [...] > > When I query the system catalog table syssynonyms [...] > > The table syssynonyms is not used in younger versions of informix. > The synonyms are stored in systables with the tabtype P. Or S. P is for private synonyms. MODE ANSI databases only support private synonyms, even though you cannot use thr PRIVATE keyword. Other database types support both PUBLIC and PRIVATE synonyms. And SysSyntable records the detailed description of the synonym. -- Yours, Jonathan Leffler (j.leffler@acm.org aka jleffler@earthlink.net) #include <too-many-aliases.h> #include <guardian-of-DBD::Informix.h> #include <disclaimer.h> #include <witticism.h>