Azure Data Studio - intellisence do not see tables in schema other than dbo
Do you know any way to force intellisence in Azure Data Studio to find tables in custom schemas?
As you can see I have tables:
When typing a query, only TableC is found by intellisence. I know that full SQL Server Management Studio does not do this by default as well but there are some extensions that do this (e.q. SqlComplete). Is there anything for Azure Data Studio with similar functionalities?
I created an issue on Azure Data Studio github. It's here: https://github.com/microsoft/azuredatastudio/issues/18514
You may need to refresh the IntelliSense cache. Previously in SSMS, this was easily achievable via the shortcut
CTRL+SHIFT+Rbut it seems that's no longer the case in Azure Data Studio.
Rather, in Azure Data Studio, you need to open the Command Palette, type in
intellisense, and then you should be able to click on
Refresh IntelliSense Cacheas per https://dba.stackexchange.com/a/298418/150011 on a similar question:
To do this in ADS, press
CTRL+SHIFT+Pto bring up the Command Palette, and type
intellisense. The drop down list will filter so you can select
Refresh IntelliSense Cachefrom the listed options.
Perhaps there's a way to https://docs.microsoft.com/en-us/sql/azure-data-studio/keyboard-shortcuts?view=sql-server-ver15 to this specific command too.