auto-table name completion prefixes with database.schema

Discussion of open issues, suggestions and bugs regarding database management and development tools for SQL Server
Post Reply
HockeyFan77
Posts: 5
Joined: Tue 25 Apr 2017 14:45

auto-table name completion prefixes with database.schema

Post by HockeyFan77 » Tue 25 Apr 2017 23:33

After the most recent update to 5.6.146, when SQL Complete automatically completes a table name, it also prefixes the table name with the database-name.schema-name. Is there a way to turn this off?

Example:
I type "select * from myT" and let SQL Complete finish the statement with "select * from myTable".
After completion, I get "select * from myDatabase.mySchema.myTable".

alexa

Re: auto-table name completion prefixes with database.schema

Post by alexa » Wed 26 Apr 2017 07:34

Could you please provide us a concrete query? A video or screenshots would be also of help. Are you using a linked server?

You can send a reply straight to our support system at supportATdevartDOTcom and alexaATdevartDOTcom .

HockeyFan77
Posts: 5
Joined: Tue 25 Apr 2017 14:45

Re: auto-table name completion prefixes with database.schema

Post by HockeyFan77 » Wed 26 Apr 2017 15:33

I sent an animated .gif showing the behavior I'm seeing.
Thanks for looking into this.

alexa

Re: auto-table name completion prefixes with database.schema

Post by alexa » Thu 27 Apr 2017 12:40

Thank you for the reply.

We will fix this issue in the next product build and will notify you once it's available for downloading.

HockeyFan77
Posts: 5
Joined: Tue 25 Apr 2017 14:45

Re: auto-table name completion prefixes with database.schema

Post by HockeyFan77 » Thu 27 Apr 2017 13:49

That's great news. I'm glad you folks were able to reproduce the error. (well, maybe not error, but you get my meaning)
Thanks again!

HockeyFan77
Posts: 5
Joined: Tue 25 Apr 2017 14:45

Re: auto-table name completion prefixes with database.schema

Post by HockeyFan77 » Wed 24 May 2017 21:25

I just wanted to post a follow-up and let you know the latest version 5.6.152 solves the problem.
Excellent work.

Oh, and I'm telling anyone who will listen what a wonderful tool this is.

Thanks again!
-Mark

alexa

Re: auto-table name completion prefixes with database.schema

Post by alexa » Thu 25 May 2017 07:52

Thank you for updating us on this issue. Please let us know if any questions arise.

Post Reply