Certain table names not returned by intellisense

[agentwalker]

• Azure Data Studio Version: 1.46
• OS Version: Windows 11

Steps to Reproduce:

1 Create a table that has a name such as EPDERTesting

2. Start writing a SQL query that looks like this

Select * from Testing

In SSMS the IntelliSense brings back the 'EPDERTesting' table. In azure data studio the table is not returned.

Even if you have multiple tables already on the database from previous sessions with a similar name structure e.g.

EPREOutput DRCities

Typing 'output' or 'cities' in ssms displays the correct tables in the intellisense popup. Azure doesn't include these even after restarting, clearing the cache.

Does this issue occur when all extensions are disabled?: Yes

[cheenamalhotra]

Hi @agentwalker

This is currently not supported, related enhancement request: https://github.com/microsoft/azuredatastudio/issues/18863 Does running "Refresh Intellisense Cache" command help refresh intellisense manually?

[cheenamalhotra]

I will close this as duplicate of https://github.com/microsoft/azuredatastudio/issues/18863

[agentwalker]

This isn't related too the issue you linked. The example I gave was just to illustrate the table name needed to cause the issue.

You can have any existing table, if it has multiple uppercase characters at the start followed by lower. Entering the lower case characters first fails to find the table. It's the uppercase characters that cause the issue.

[agentwalker]

@cheenamalhotra Can this be reopened as ssms doesn't have the same issue so using intellisense often misses tables.

I've updated the original post with extra details

[cheenamalhotra]

Thanks for providing additional info @agentwalker - I've reopened the issue for investigation into case sensitivity.