CDC System Tables Not Visible under user database

[mwc360]

When browsing a SQL Sever DB in ADS, I can't see system tables within the table folder. When accessing the same DB in SSMS I am able to see all of the system tables (i.e. cdc schema tables).

I am able to query from the system (i.e. cdc.change_tables) but it isn't visible in the server explorer view.

Version: 1.19.0 (user setup) Commit: 4095037f2578c23033867e611e82c13de114ca5a Date: 2020-06-11T22:06:05.429Z VS Code: 1.46.0 Electron: 7.2.4 Chrome: 78.0.3904.130 Node.js: 12.8.1 V8: 7.8.279.23-electron.0 OS: Windows_NT x64 10.0.18363

[kburtram]

@mwc360 you should be able to view the system tables by looking under one of the system databases (e.g. master, model, tempdb, etc.). Please let me know if you don't see them there.

[mwc360]

I did already look there and didn’t find them. CDC generates tables aren’t stored in the master\etc. databases. In SSMS they show up under the database with CDC enabled in a System tables folder.

---

From: Karl Burtram [email protected] Sent: Monday, July 27, 2020 10:32:08 AM To: microsoft/azuredatastudio [email protected] Cc: mwc360 [email protected]; Mention [email protected] Subject: Re: [microsoft/azuredatastudio] System Tables Not Visible (#11511)

@mwc360https://github.com/mwc360 you should be able to view the system tables by looking under one of the system databases (e.g. master, model, tempdb, etc.). Please let me know if you don't see them there.

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHubhttps://github.com/microsoft/azuredatastudio/issues/11511#issuecomment-664502857, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AMOKQ6HADBSD3VXB3MKQO63R5WTYRANCNFSM4PHACWOQ.

[kburtram]

@mwc360 thanks for clarifying that this is related to CDC system tables.

[rubahness]

I wanted to chime in that this is very frustrating, as not only do CDC tables not appear in the object explorer, but I can only view the system functions like sys.fn_cdc_get_min_lsn() by connecting to the master database, which may not always be an option. Plus, trying to view the definition for the functions from the non-master db only shows the definition for creating the sys schema.

It would be appreciated if there could be a check box like SSMS has where you can just show all those system objects or not.

[danieltroyer]

We have a "group by schema" option in ADS, but when we use it, almost none of the schemas are populated. I'm connecting to Azure SQL Databases with CDC enabled. dbo and Maintenance return table names but sys and cdc do not. I've confirmed that I can view these tables through SSMS browser and I can query them even in ADS, but I can't view them in the ADS browser. This is a major blocker for my team to be able to transition from SSMS to ADS.

My environment: Azure Data Studio Version: 1.44.1 Commit: 8f53a316fa00a98264f1ab119641cd540b5af25c Date: 2023-06-01T02:13:52.990Z (5 days ago) VS Code: 1.70.0 Electron: 19.1.8 Chromium: 102.0.5005.167 Node.js: 16.14.2 V8: 10.2.154.15-electron.0 OS: Darwin arm64 22.3.0

My colleague has confirmed this issue on ADS for Windows as well.

[lindenquan]

It's been almost 4 years now. Not interested in solving this issue ?

[sgreenfield]

This issue is still present. Not being able to see system tables makes this program nearly worthless. Any chance this major flaw will be addressed? Back to SSMS I go, sadly. My retinas will not be pleased.