Search code examples
visual-studio-codevscode-extensions

Group tables by schema in vscode-extension mssql

This question is similar to the question here, but for vscode rather than SSMS.

In Vscode a popular extension for connecting to SQL servers is the mssql extension. But in the best SQL server fashion, tables are not grouped by schema. Is there a viable method (either through settings, existing extensions or extending the extension oneself) to group tables by schema?

For example in the below image the 3 tables would be grouped under the "extract" schema, so the folder structure would be "db/tables/{schemaname}/{tablename}" (or alternatively "db/schemma/{schemaname}/{tablename}" as in DBeaver)

vscode-db-image

Solution

  • Azure Data Studio 1.42 supports Group By Schema feature.

    Announcing the Release of Azure Data Studio 1.42 by Erin Stellato

    One of the original feature requests for Azure Data Studio was the ability to view objects by schema in Object Explorer (OE). Finally, that functionality is available in this release for the MSSQL provider:

    enter image description here

    The default behavior shows the objects grouped by type (Tables, Views, etc.) and can be quickly toggled by clicking the branching icon in the Servers View. The configuration persists through restarts of Azure Data Studio, and it applies across all MSSQL connections; it is not selective to instance or database.