Re: synonyms

Paul wrote: > > I have created severl synonyms but I have not been able to see them in the > system catalog. > When I query the system catalog table syssynonyms I get the display with > the columns of syssynonyms but no rows. But if I drop the synonym I get a > good message that the action was completed. Where am I going wrong? The table syssynonyms is not used in younger versions of informix. The synoyms are stored in systables with the tabtype P. To check your synonyms you must query in this way: select * from "informix".systables where tabtype = "P" --Gru' Katrin __________ _/_/_/_/_/ _/_/_/_/ _/_/_/_/ Katrin Goericke katrin@taz.de _/ _/ _/ _/ die tageszeitung _/ _/_/_/_/ _/ Germany _/ _/ _/ _/ D-10969 Berlin Phone: +49-30-2516092 _/ _/ _/ _/_/_/_/ Kochstr. 18 FAX : +49-30-2510694