I just recently downloaded Azure Data Studio with SQL Server Express since I'm using Linux . Is there an entity-relationship diagramming feature, kind of how SQL Server Management Studio has a database diagram feature? I want to visually see the relationships with tables in a database if possible.
To open a database diagramDouble-click the name of the database diagram you want to open. Right-click the name of the database diagram you want to open, and then choose Design Database Diagram.
Open a new database diagramRight-click the Database Diagrams node of your database in Object Explorer. From the drop-down menu, click New Database Diagram. In the Add Table dialog box, choose tables to work with in the diagram.
Leaving this here for future people asking this question. While Azure Data Studio does not support this, DBeaver does and it's cross platform. https://dbeaver.io/
I had this same issue and by right clicking the dbo under your databases Schemas folder in the database explorer, you can choose "View Diagram" and it will build a view just like SQL Server Management Studio does.
I don't know if you're still looking for an extension to do that. Anyhow, I've solved with the R0tenur/visualization.
This extension uses mermaid.js to generate the schema.
If you want to install (v0.7.1) it, just look at here, download the vsix file, and install it from the File -> Install Extension from VSIX Package in Azure Data Studio.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With