SQL Complete doesn't suggest objects from another database without using schema name first

Discussion of open issues, suggestions and bugs regarding database management and development tools for SQL Server
Post Reply
Thenrich
Posts: 105
Joined: Sun 21 Dec 2014 19:47

SQL Complete doesn't suggest objects from another database without using schema name first

Post by Thenrich » 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?

alexa

Re: SQL Complete doesn't suggest objects from another database without using schema name first

Post by alexa » Fri 17 Jun 2016 10:38

This will be resolved in the new product version that is to be released this month.

Post Reply