Steps to reproduce this issue

1. Connect to any MSSQL server
2. Write SQL query and double click any table name to insert in from clause; inserted table name has schema prepended, e.g. dbo.example.
3. Alias table, e.g. select * from dbo.example e …
4. In where clause type e. and wait for autocomplete of column names – does not appear

Current behavior

Autocomplete popup does not appear

Expected behavior

Autocomplete popup appears

Possible solution

Any one of the following would solve the issue:

1. Respect schema name when looking up columns in system tables
2. Ignore schema name when inserting table name into query editor (e.g. insert example instead of dbo.example)

While 2. might be easier to implement, I think 1. is the preferred solution as it should also make more complex names autocomplete (e.g. dbo.example.…).

Currently, my slightly tedious workaround is to remove the schema name from the inserted table name (basically solution 2. in manual steps).

Environment

• HeidiSQL version: 10.1.0.5464
• Database system and version: Microsoft SQL Server