Table Field List with Synonyms
Posted: 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!
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!