I am using SQL Complete standard edition latest version. If I am in database1 in the query window and I want to write a query which targets another database2 and some tables in database2 belong to different schemas, SQL Complete doesn't give table names suggestion before having me to type the schema first.
Example:
I have a table called john.customer in database 2.
While in database 1, I can't type database2.cus... and get a list of tables names starting with cus. and the schema name to the right. I have to type database2.john.cus..
The problem is that I know there's a table called customer but I do not know which schema it is in. It works if my context is in database2. So why don't the suggestions work fully across databases?
SQL Complete doesn't suggest objects from another database without using schema name first
Re: SQL Complete doesn't suggest objects from another database without using schema name first
This will be resolved in the new product version that is to be released this month.