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

  • I know this is an old question but now you have this option in the extension

    "mssql.objectExplorer.groupBySchema": true