Re:

You bet. We use them to change lookup tables. We have various lookup tables we use that are identical in structure but contain different data (tables for weekdays, Saturdays and Sundays). We use a synomym to point to the correct table. We change the synonym when we need to point to another table, and we can do with with minimal disruption to our users (24x7 environment). ----- Original Message ----- From: "Dusty Spellman" <dustyspellman@hotmail.com> To: <informix-list@iiug.org> Sent: Friday, December 01, 2000 11:41 AM > I have been reading up on the Informix SQL extension CREATE SYMONYM, and > although I understand the mechanincs of a synonym, I cannot think of a good > application for them. Does anyone use them? > ____________________________________________________________________________ _________ > Get more from the Web. FREE MSN Explorer download : http://explorer.msn.com