SQL Complete doesn't suggest objects from another database without using schema name first
Posted: Thu 16 Jun 2016 19:40
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?
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?