Browsing for a synonym jumps to the table

[Ivan C.]

We had a private synonym for a table.
In order to navigate to the synonym in Object Browser from a SQL Window, I right-click synonym's name and chose Browse. However, that jumps to the table (in Object Browser), not to the synonym. If the developer is not careful, he may right-click the object in the Object Browser, and chose Drop, thinking that he's dropping the synonym... It happened in our team.

Please fix it.

Reproduce:

1. drop table test_drop_synonym;
2. create table test_drop_synonym(a int);
3. create synonym tst_drp_syn for test_drop_synonym;
4. From the SQL Window, right-click on synonym's name, tst_drp_syn and choose Browse

Table test_drop_synonym is picked in Object Browser, instead of synonym tst_drp_syn.

 

[Ivan C.]

Furthermore, if we right-click on the synonym name (in SQL Window) and choose Drop, and not be careful what the pop-up says, or click the Don't show this message again, we'll be dropping the table, instead of synonyms.

 

[Marco Kalter]

I have added this to the list of enhancement requests.