search

microsoft / azuredatastudio

Azure Data Studio is a data management and development tool with connectivity to popular cloud and on-premises databases. Azure Data Studio supports Windows, macOS, and Linux, with immediate capability to connect to Azure SQL and SQL Server. Browse the extension library for more database support options including MySQL, PostgreSQL, and MongoDB.
https://learn.microsoft.com/sql/azure-data-studio
MIT License
7.55k stars 898 forks source link

Intellisense does not recognize new objects in database #18863

Open dotKek opened 2 years ago

dotKek commented 2 years ago

Issue Type: Bug

Hello Once views and functions are created, they are not recognized in Intellisense until ADS is restarted unlike it work in SSMS

Azure Data Studio version: azuredatastudio 1.35.1 (fab63efd307e54c063c8af03474bbb5d77f5fd11, 2022-03-15T18:03:38.261Z) OS version: Windows_NT x64 10.0.19044 Restricted Mode: No

Extensions (15) Extension|Author (truncated)|Version ---|---|--- sql-server-diagnostic-book|ema|0.2.0 qpi|joc|0.1.6 admin-pack|Mic|0.0.2 admin-tool-ext-win|Mic|0.0.3 agent|Mic|0.48.0 dacpac|Mic|1.8.0 import|Mic|1.5.0 profiler|Mic|0.11.0 query-history|Mic|0.1.0 server-report|Mic|0.2.3 sql-assessment|Mic|0.6.1 azdata-sanddance|msr|3.3.0 schema-visualization|R0t|0.8.2 sql-prompt|Red|0.2.10 vscodeintellicode|Vis|1.2.1 (1 theme extensions excluded)
kburtram commented 2 years ago

@ragnarok154 there is a command Refresh Intellisense Cache available that should update suggestions, etc. when the DB schema changes. This should be similar to SSMS which contains a similar command. We would like to implement schema drift-detection like SSDT which automatically detects schema changes, but don't have that support currently. Please let us know if this command does not work as expected. Thanks!