Table Field List with Synonyms

Discussion of open issues, suggestions and bugs regarding database management and development tools for SQL Server
Post Reply
bentleycloaks
Posts: 1
Joined: Mon 17 Oct 2016 15:05

Table Field List with Synonyms

Post by bentleycloaks » Mon 17 Oct 2016 15:33

We're using SQL Complete version 4.8.33 and are having the following issue. We have two production databases one with the data (production) and the other with synonyms for each of the tables on the other database (staging). We noticed that on staging when listing the synonym SQL complete has no issue, but the field list for the table do not come up.

Working:
synonymschema.synonym

Not Working:
synonymschema.synonym.field


Is there a way to use SQL complete so we can have the field list for our tables when our tables are referenced through synonyms? Would upgrading to 5.5.215 resolve this issue?

Thank you!

alexa

Re: Table Field List with Synonyms

Post by alexa » Thu 20 Oct 2016 07:45

We were not able to reproduce this issue on the latest version 5.5.

Please try the fully featured 30-day Trial version https://www.devart.com/dbforge/sql/sqlc ... nload.html

Post Reply