Azure SQL Database
An Azure relational database service.
See some details:
Azure Data Studio not showing system views
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(307.2, 55.00000000000001%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ%3C/text%3E%3C/svg%3E)
Joe
0
Reputation points
I have recently started using Azure Data Studio as well as SSMS.
If I connect to a database in SSMS and go to the object explorer under views there is a system views folder that I can browse.
If I connect to the same database in Azure Data Studio using the same credentials I cannot see the the system views folder in the object explorer. I can still query the views but I can't see them to browse which is inconvenient.
Is there a setting somewhere that in Azure or Azure Data Studio that allows the system views to be visible in the object explorer?
Azure SQL Database
Azure Data Studio
Azure Data Studio
A cross-platform database tool for data professionals using on-premises and cloud data platforms on Windows, macOS, and Linux.
{count} votes
-
Vahid Ghafarpour 23,585 Reputation points Volunteer Moderator2023-06-03T05:09:37.7033333+00:00 In Azure Data Studio, the object explorer might not show the system views folder by default. However, you can enable the display of system objects, including system views, by adjusting the settings. Here's how you can do it:
- Open Azure Data Studio.
- Go to the "File" menu and select "Preferences," then choose "Settings" (or you can use the keyboard shortcut Ctrl + , to directly access the settings).
- In the settings panel, navigate to the "Extensions" section.
- Expand the "Azure Data Studio" section.
- Click on "Object Explorer" in the left-hand menu.
- Scroll down in the right-hand pane until you find the "Object Explorer: Expand System Objects" option.
- Enable the checkbox for "Object Explorer: Expand System Objects" to display system objects in the object explorer, including system views.
- Close the settings.
After making this change, the object explorer in Azure Data Studio should now display the system views folder, allowing you to browse them directly.
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(28.799999999999997, 33%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
sguidos 15 Reputation points2024-12-13T14:59:59.1833333+00:00 I do not see "Azure Data Studio" under the "Extensions" section, what am I missing? Also searching for "Expand System" returns no results.
Sign in to comment
1 answer
Sort by: Most helpful
-
Viorel 125.3K Reputation points2023-06-03T06:54:33.39+00:00 -
GeethaThatipatri-MSFT 29,582 Reputation points Microsoft Employee Moderator2023-06-05T23:04:55.26+00:00
Sign in to comment -