RE:

they save you keystrokes by shorting table names. they also work well in a ASCII environment like ours so we don't have to type in the owner of the table too. create public synonym for res on "psoft7".ps_proj_resource; -----Original Message----- From: Dusty Spellman [mailto:dustyspellman@hotmail.com] Sent: Friday, December 01, 2000 1:42 PM To: informix-list@iiug.org Subject: 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