Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Azure data studio schema diagram?

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.

like image 302
badugi Avatar asked Nov 14 '18 04:11

badugi


People also ask

How do I find schema diagrams in SQL Server?

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.

How do I view the database diagram in Visual Studio?

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.


Video Answer


2 Answers

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.

like image 65
cmw2379 Avatar answered Oct 05 '22 15:10

cmw2379


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.

like image 33
Samuele Furnari Avatar answered Oct 05 '22 15:10

Samuele Furnari