Start a new topic

informix synonyms

[This topic is migrated from our old forums. The original author name has been removed]

hi i use synonyms to point to tables in other databases from OTHER informix instances. when browsing synonyms in dbvis only the database is listed, without the database instance (separate informix server). what is shown in dbvis: synonym_name,synonym_owner,db_name,table_owner,table_name,synonym_type the syntax i use to define synonyms: create synonym "synonym_owner".synonym_name for db_name@instance_name:"table_owner".table_name; would be nice if dbvisualizer would show synonyms as synonym_name,synonym_owner,db_name,INSTANCE_NAME,table_owner,table_name,synonym_type or at least synonym_name,synonym_owner,db_name@INSTANCE_NAME,table_owner,table_name,synonym_type also, would be nice if we had a ddl tab for synonyms (showing the command used to create the synonym) Edited by: Ardealul on Jun 15, 2011 8:48 AM
1 Comment

[This reply is migrated from our old forums.]

Re: informix synonyms
Ardealul, Thanks for the suggestion. I'll open a ticket for this. Regards Roger