{"id":2696,"date":"2023-02-28T08:00:04","date_gmt":"2023-02-28T13:00:04","guid":{"rendered":"https:\/\/www.dpriver.com\/blog\/?p=2696"},"modified":"2023-12-18T09:53:36","modified_gmt":"2023-12-18T14:53:36","slug":"convert-sql-into-e-r-diagram-with-sqlflow","status":"publish","type":"post","link":"https:\/\/www.dpriver.com\/blog\/convert-sql-into-e-r-diagram-with-sqlflow\/","title":{"rendered":"Convert SQL into E-R Diagram with SQLFlow"},"content":{"rendered":"\n<p>Checking for a new erd online tool in 2023\/2024?<\/p>\n\n\n\n<p><a href=\"http:\/\/sqlflow.gudusoft.com\/#\/\" target=\"_blank\" rel=\"noreferrer noopener\">SQLFlow<\/a> is capable to convert <strong>SQL to Entity-Relation(ER) Diagram<\/strong> as well as to visualize the relations between tables and fields so that you can quickly understand the design model of the database and conduct efficient team communication. <\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Two Sources of Visualization ER Model<a href=\"https:\/\/app.gitbook.com\/o\/8tYHSVB0mG81POwyVWfj\/s\/HPaNIbjpxIoccnaNkyJQ\/1.-introduction\/getting-started\/convert-sql-to-e-r-diagram#two-sources-of-visualization-er-model\"><\/a><\/h2>\n\n\n\n<ul>\n<li><strong>From SQL Script<\/strong><\/li>\n<\/ul>\n\n\n\n<p>SQLFlow can analyze Database creation SQL script and visualize the provided scripts. In order to create ER diagram, user need to provide SQL statements such as <code>create table<\/code> or <code>alter table<\/code> and include foreign keys.<\/p>\n\n\n\n<ul>\n<li><strong>From Database<\/strong><\/li>\n<\/ul>\n\n\n\n<p>You can simply make SQLFlow connect to your database for the ER diagram. SQLFlow will automatically retrieve metadata from the database and generate the ER diagram.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Three Ways to Visualize ER Model<\/h2>\n\n\n\n<p>Let&#8217;s now take a look on how exactly to use <a href=\"https:\/\/sqlflow.gudusoft.com\/#\/\" target=\"_blank\" rel=\"noreferrer noopener\">Gudu SQLFlow<\/a>.<\/p>\n\n\n\n<p><a href=\"https:\/\/sqlflow.gudusoft.com\/#\/\" target=\"_blank\" rel=\"noreferrer noopener\">Gudu SQLFlow<\/a> provides three ways:<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">1. Paste SQL Statements into the SQLText Editor<a href=\"https:\/\/app.gitbook.com\/o\/8tYHSVB0mG81POwyVWfj\/s\/HPaNIbjpxIoccnaNkyJQ\/1.-introduction\/getting-started\/convert-sql-to-e-r-diagram#1.-paste-sql-statements-into-the-sqltext-editor\"><\/a><\/h4>\n\n\n\n<p>Directly paste your SQL statements into the SQLText Editor<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" loading=\"lazy\" width=\"669\" height=\"619\" src=\"https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2023\/02\/image.png\" alt=\"\" class=\"wp-image-2700\" srcset=\"https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2023\/02\/image.png 669w, https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2023\/02\/image-300x278.png 300w\" sizes=\"(max-width: 669px) 100vw, 669px\" \/><\/figure>\n\n\n\n<p>Click the icon of the ER model and you will have the correspond ER diagram instantly.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" loading=\"lazy\" width=\"657\" height=\"189\" src=\"https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2023\/02\/image-1.png\" alt=\"\" class=\"wp-image-2701\" srcset=\"https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2023\/02\/image-1.png 657w, https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2023\/02\/image-1-300x86.png 300w\" sizes=\"(max-width: 657px) 100vw, 657px\" \/><\/figure>\n\n\n\n<p>Result:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"1009\" height=\"1024\" src=\"https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2023\/12\/\u5fae\u4fe1\u622a\u56fe_20231218225252-1009x1024.png\" alt=\"\" class=\"wp-image-2987\" srcset=\"https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2023\/12\/\u5fae\u4fe1\u622a\u56fe_20231218225252-1009x1024.png 1009w, https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2023\/12\/\u5fae\u4fe1\u622a\u56fe_20231218225252-296x300.png 296w, https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2023\/12\/\u5fae\u4fe1\u622a\u56fe_20231218225252-768x779.png 768w, https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2023\/12\/\u5fae\u4fe1\u622a\u56fe_20231218225252.png 1181w\" sizes=\"(max-width: 1009px) 100vw, 1009px\" \/><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\">2. Upload SQL files<\/h4>\n\n\n\n<p>Click <code>upload sql<\/code><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" loading=\"lazy\" width=\"665\" height=\"184\" src=\"https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2023\/02\/image-2.png\" alt=\"\" class=\"wp-image-2702\" srcset=\"https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2023\/02\/image-2.png 665w, https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2023\/02\/image-2-300x83.png 300w\" sizes=\"(max-width: 665px) 100vw, 665px\" \/><\/figure>\n\n\n\n<p>Choose <code>upload file<\/code> as the job source and choose the SQL type in the <code>dbvendor<\/code>. Upload file and create the Job.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" loading=\"lazy\" width=\"599\" height=\"466\" src=\"https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2023\/02\/image-3.png\" alt=\"\" class=\"wp-image-2703\" srcset=\"https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2023\/02\/image-3.png 599w, https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2023\/02\/image-3-300x233.png 300w\" sizes=\"(max-width: 599px) 100vw, 599px\" \/><\/figure>\n\n\n\n<p>Choose the job in the job list panel when it is complete.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" loading=\"lazy\" width=\"392\" height=\"605\" src=\"https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2023\/02\/image-4.png\" alt=\"\" class=\"wp-image-2704\" srcset=\"https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2023\/02\/image-4.png 392w, https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2023\/02\/image-4-194x300.png 194w\" sizes=\"(max-width: 392px) 100vw, 392px\" \/><\/figure>\n\n\n\n<p>Click <code>show ER diagram<\/code> in the schema explorer and check the result.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" loading=\"lazy\" width=\"389\" height=\"299\" src=\"https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2023\/02\/image-5.png\" alt=\"\" class=\"wp-image-2705\" srcset=\"https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2023\/02\/image-5.png 389w, https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2023\/02\/image-5-300x231.png 300w\" sizes=\"(max-width: 389px) 100vw, 389px\" \/><\/figure>\n\n\n\n<p>Result:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"1024\" height=\"584\" src=\"https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2023\/12\/\u5fae\u4fe1\u622a\u56fe_20231210165309-1024x584.png\" alt=\"\" class=\"wp-image-2942\" srcset=\"https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2023\/12\/\u5fae\u4fe1\u622a\u56fe_20231210165309-1024x584.png 1024w, https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2023\/12\/\u5fae\u4fe1\u622a\u56fe_20231210165309-300x171.png 300w, https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2023\/12\/\u5fae\u4fe1\u622a\u56fe_20231210165309-768x438.png 768w, https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2023\/12\/\u5fae\u4fe1\u622a\u56fe_20231210165309.png 1321w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\">3. Connect to DB<\/h4>\n\n\n\n<p>Connect to your database for the ER diagram, check following table for the supported database types and the permissions\/roles needed:<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td><strong>Database Type<\/strong><\/td><td><strong>Permissions\/Roles required<\/strong><\/td><td><strong>Comment<\/strong><\/td><\/tr><tr><td>MySQL<\/td><td>SELECT<\/td><td>ER Diagram needs DB user to have SELECT permission<\/td><\/tr><tr><td>PostgreSQL<\/td><td>SELECT<\/td><td>ER Diagram needs DB user to have SELECT permission<\/td><\/tr><tr><td>SQL Server<\/td><td>SELECT<\/td><td>ER Diagram needs DB user to have SELECT permission<\/td><\/tr><tr><td>Oracle<\/td><td>DBA<\/td><td>To generate ER Diagram from Oracle database, input user must has DBA role , otherwise <code>ORA-01031<\/code> will be returned.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p><em>Hint: Other databases are not in current version&#8217;s support list and will be supported in our future release<\/em><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" loading=\"lazy\" width=\"592\" height=\"515\" src=\"https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2023\/02\/\u56fe\u7247-11.png\" alt=\"\" class=\"wp-image-2707\" srcset=\"https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2023\/02\/\u56fe\u7247-11.png 592w, https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2023\/02\/\u56fe\u7247-11-300x261.png 300w\" sizes=\"(max-width: 592px) 100vw, 592px\" \/><\/figure>\n\n\n\n<p>Choose the job in the job list panel when it is complete.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" loading=\"lazy\" width=\"392\" height=\"605\" src=\"https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2023\/02\/\u56fe\u7247-12.png\" alt=\"\" class=\"wp-image-2708\" srcset=\"https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2023\/02\/\u56fe\u7247-12.png 392w, https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2023\/02\/\u56fe\u7247-12-194x300.png 194w\" sizes=\"(max-width: 392px) 100vw, 392px\" \/><\/figure>\n\n\n\n<p>Click <code>show ER diagram<\/code> in the schema explorer and check the result.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" loading=\"lazy\" width=\"389\" height=\"299\" src=\"https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2023\/02\/\u56fe\u7247-13.png\" alt=\"\" class=\"wp-image-2709\" srcset=\"https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2023\/02\/\u56fe\u7247-13.png 389w, https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2023\/02\/\u56fe\u7247-13-300x231.png 300w\" sizes=\"(max-width: 389px) 100vw, 389px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">E-R Diagram<\/h2>\n\n\n\n<p>The following capture is the ER diagram of <a href=\"https:\/\/github.com\/pthom\/northwind\\_psql\" target=\"_blank\" rel=\"noreferrer noopener\">Northwind database<\/a> generated by <a href=\"https:\/\/sqlflow.gudusoft.com\/#\/\" target=\"_blank\" rel=\"noreferrer noopener\">Gudu SQLFlow<\/a>. We will have tables, fields, field types and different kinds of key which are under different icons in the diagram.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"837\" height=\"1024\" src=\"https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2023\/02\/\u56fe\u7247-14-837x1024.png\" alt=\"\" class=\"wp-image-2710\" srcset=\"https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2023\/02\/\u56fe\u7247-14-837x1024.png 837w, https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2023\/02\/\u56fe\u7247-14-245x300.png 245w, https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2023\/02\/\u56fe\u7247-14-768x940.png 768w, https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2023\/02\/\u56fe\u7247-14.png 1072w\" sizes=\"(max-width: 837px) 100vw, 837px\" \/><\/figure>\n\n\n\n<p>The following ER diagram is a simple <a href=\"https:\/\/github.com\/thekordy\/ticketit\" target=\"_blank\" rel=\"noreferrer noopener\">help-desk tickets system<\/a> generate by <a href=\"https:\/\/sqlflow.gudusoft.com\/#\/\" target=\"_blank\" rel=\"noreferrer noopener\">Gudu SQLFlow<\/a> from the <a href=\"https:\/\/e.gitee.com\/gudusoft\/repos\/gudusoft\/sqldepot\/blob\/master\/sql2er\/drawsql\/ticketit.sql\" target=\"_blank\" rel=\"noreferrer noopener\">SQL file<\/a>.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" loading=\"lazy\" width=\"855\" height=\"586\" src=\"https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2023\/02\/\u56fe\u7247-18.png\" alt=\"\" class=\"wp-image-2717\" srcset=\"https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2023\/02\/\u56fe\u7247-18.png 855w, https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2023\/02\/\u56fe\u7247-18-300x206.png 300w, https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2023\/02\/\u56fe\u7247-18-768x526.png 768w\" sizes=\"(max-width: 855px) 100vw, 855px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">SQL Requirements to Create ER Diagram<\/h2>\n\n\n\n<p>In order to create ER diagram, foreign keys should be included in the provided SQL files. Other keys such as primary key, index key or unique key are not mandatory.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">A. Foreign key<\/h4>\n\n\n\n<p>Foreign key is to build ER relations between different tables. Statements such as <code>create table<\/code> and <code>alter table<\/code> usually contain this information.<\/p>\n\n\n\n<p><strong>1. Foreign key in create table<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE TABLE SCOTT.EMP \n   (\t\n\tEMPNO NUMBER(4,0), \n\tENAME VARCHAR2(10), \n\tDEPTNO NUMBER(2,0), \n\tCONSTRAINT PK_EMP PRIMARY KEY (EMPNO),\n\tFOREIGN KEY(DEPTNO) REFERENCES SCOTT.DEPT(DEPTNO)\n   );<\/code><\/pre>\n\n\n\n<p><strong>2. Foreign key in alter table<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>ALTER TABLE SCOTT.EMP ADD CONSTRAINT FK_DEPTNO FOREIGN KEY (\"DEPTNO\")\n\t  REFERENCES SCOTT.DEPT (\"DEPTNO\") ENABLE;<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\">B. Primary key, index key, unique key<\/h4>\n\n\n\n<p><strong>1. Primary key<a href=\"https:\/\/docs.gudusoft.com\/1.-introduction\/getting-started\/convert-sql-to-e-r-diagram#1.-primary-key\"><\/a><\/strong><\/p>\n\n\n\n<p>Primary key can be specified in <code>create table<\/code> and <code>alter table<\/code> statement.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE TABLE SCOTT.EMP \n   (\t\n\tEMPNO NUMBER(4,0), \n\tENAME VARCHAR2(10), \n\tDEPTNO NUMBER(2,0), \n\tCONSTRAINT PK_EMP PRIMARY KEY (EMPNO),\n\tFOREIGN KEY(DEPTNO) REFERENCES SCOTT.DEPT(DEPTNO)\n   );<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code>ALTER TABLE SCOTT.DEPT\nADD CONSTRAINT dept_pk PRIMARY KEY (DEPTNO);<\/code><\/pre>\n\n\n\n<p>Icon of <strong>primary key in ER diagram<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" loading=\"lazy\" width=\"215\" height=\"28\" src=\"https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2023\/02\/\u56fe\u7247-15.png\" alt=\"\" class=\"wp-image-2711\"\/><\/figure>\n\n\n\n<p><strong>2. Unique key<\/strong><\/p>\n\n\n\n<p>Unique key can be specified in <code>create table<\/code> and <code>alter table<\/code> statement.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE TABLE SCOTT.DEPT \n   (\n    DEPTNO NUMBER(2,0), \n\tDNAME VARCHAR2(14), \n\tLOC VARCHAR2(13),\n\tCONSTRAINT constraint_name UNIQUE (DEPTNO)\n   ) ;<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code>ALTER TABLE SCOTT.DEPT \nADD CONSTRAINT constraint_name UNIQUE (DEPTNO);  <\/code><\/pre>\n\n\n\n<p>Icon of<strong> unique key in ER diagram<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" loading=\"lazy\" width=\"209\" height=\"29\" src=\"https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2023\/02\/\u56fe\u7247-16.png\" alt=\"\" class=\"wp-image-2712\"\/><\/figure>\n\n\n\n<p><strong>3. Index key<\/strong><\/p>\n\n\n\n<p>Index key can be specified using <code>create index<\/code> statement.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>-- Oracle\nCREATE INDEX SCOTT.DEPT_INDEX \nON SCOTT.DEPT (LOC);<\/code><\/pre>\n\n\n\n<p>Or alter table add index<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>-- MySQL\nALTER TABLE\n    `ticketit` ADD INDEX `ticketit_subject_index`(`subject`);<\/code><\/pre>\n\n\n\n<p>Icon of <strong>index key in ER diagram<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" loading=\"lazy\" width=\"209\" height=\"30\" src=\"https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2023\/02\/\u56fe\u7247-17.png\" alt=\"\" class=\"wp-image-2713\"\/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>key word: erd generator from sql, sql code to er diagram, sql to erd, generate er diagram from sql online, sql to er diagram online, sql to er diagram<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Checking for a new erd online tool in 2023\/2024? SQLFlow is capable to convert SQL to Entity-Relation(ER) Diagram as well as to visualize the relations between tables and fields so that you can quickly understand the design model of the database and conduct efficient team communication. Two Sources of Visualization ER Model SQLFlow can analyze Database creation SQL script and visualize the provided scripts. In order to create ER diagram, user need to provide SQL statements such as create table or alter table and include foreign keys. You can simply make SQLFlow connect to your database for the ER diagram.\u2026<\/p>\n","protected":false},"author":6,"featured_media":2710,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[66,93],"tags":[],"blocksy_meta":{"styles_descriptor":{"styles":{"desktop":"","tablet":"","mobile":""},"google_fonts":[],"version":5}},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v19.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Convert SQL into E-R Diagram with SQLFlow<\/title>\n<meta name=\"description\" content=\"Convert SQL into E-R Diagram with SQLFlow, from SQL to ER Diagram\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dpriver.com\/blog\/convert-sql-into-e-r-diagram-with-sqlflow\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Convert SQL into E-R Diagram with SQLFlow\" \/>\n<meta property=\"og:description\" content=\"Convert SQL into E-R Diagram with SQLFlow, from SQL to ER Diagram\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dpriver.com\/blog\/convert-sql-into-e-r-diagram-with-sqlflow\/\" \/>\n<meta property=\"og:site_name\" content=\"SQL and Data Blog\" \/>\n<meta property=\"article:published_time\" content=\"2023-02-28T13:00:04+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-18T14:53:36+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2023\/02\/\u56fe\u7247-14.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1072\" \/>\n\t<meta property=\"og:image:height\" content=\"1312\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"leo gu\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"leo gu\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.dpriver.com\/blog\/#organization\",\"name\":\"SQL and Data Blog\",\"url\":\"https:\/\/www.dpriver.com\/blog\/\",\"sameAs\":[],\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dpriver.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2022\/07\/sqlpp-character.png\",\"contentUrl\":\"https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2022\/07\/sqlpp-character.png\",\"width\":251,\"height\":72,\"caption\":\"SQL and Data Blog\"},\"image\":{\"@id\":\"https:\/\/www.dpriver.com\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dpriver.com\/blog\/#website\",\"url\":\"https:\/\/www.dpriver.com\/blog\/\",\"name\":\"SQL and Data Blog\",\"description\":\"SQL related blog for database professional\",\"publisher\":{\"@id\":\"https:\/\/www.dpriver.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dpriver.com\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dpriver.com\/blog\/convert-sql-into-e-r-diagram-with-sqlflow\/\",\"url\":\"https:\/\/www.dpriver.com\/blog\/convert-sql-into-e-r-diagram-with-sqlflow\/\",\"name\":\"Convert SQL into E-R Diagram with SQLFlow\",\"isPartOf\":{\"@id\":\"https:\/\/www.dpriver.com\/blog\/#website\"},\"datePublished\":\"2023-02-28T13:00:04+00:00\",\"dateModified\":\"2023-12-18T14:53:36+00:00\",\"description\":\"Convert SQL into E-R Diagram with SQLFlow, from SQL to ER Diagram\",\"breadcrumb\":{\"@id\":\"https:\/\/www.dpriver.com\/blog\/convert-sql-into-e-r-diagram-with-sqlflow\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dpriver.com\/blog\/convert-sql-into-e-r-diagram-with-sqlflow\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dpriver.com\/blog\/convert-sql-into-e-r-diagram-with-sqlflow\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.dpriver.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Convert SQL into E-R Diagram with SQLFlow\"}]},{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dpriver.com\/blog\/convert-sql-into-e-r-diagram-with-sqlflow\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dpriver.com\/blog\/convert-sql-into-e-r-diagram-with-sqlflow\/\"},\"author\":{\"name\":\"leo gu\",\"@id\":\"https:\/\/www.dpriver.com\/blog\/#\/schema\/person\/9e80d249b6da4e572bd8590b0789bc14\"},\"headline\":\"Convert SQL into E-R Diagram with SQLFlow\",\"datePublished\":\"2023-02-28T13:00:04+00:00\",\"dateModified\":\"2023-12-18T14:53:36+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dpriver.com\/blog\/convert-sql-into-e-r-diagram-with-sqlflow\/\"},\"wordCount\":541,\"publisher\":{\"@id\":\"https:\/\/www.dpriver.com\/blog\/#organization\"},\"articleSection\":[\"Data Governance\",\"SQLFlow\"],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dpriver.com\/blog\/#\/schema\/person\/9e80d249b6da4e572bd8590b0789bc14\",\"name\":\"leo gu\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dpriver.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/24976e2e4ca7dd476652bb26bd09392b?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/24976e2e4ca7dd476652bb26bd09392b?s=96&d=mm&r=g\",\"caption\":\"leo gu\"},\"url\":\"https:\/\/www.dpriver.com\/blog\/author\/guyuanhao\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Convert SQL into E-R Diagram with SQLFlow","description":"Convert SQL into E-R Diagram with SQLFlow, from SQL to ER Diagram","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dpriver.com\/blog\/convert-sql-into-e-r-diagram-with-sqlflow\/","og_locale":"en_US","og_type":"article","og_title":"Convert SQL into E-R Diagram with SQLFlow","og_description":"Convert SQL into E-R Diagram with SQLFlow, from SQL to ER Diagram","og_url":"https:\/\/www.dpriver.com\/blog\/convert-sql-into-e-r-diagram-with-sqlflow\/","og_site_name":"SQL and Data Blog","article_published_time":"2023-02-28T13:00:04+00:00","article_modified_time":"2023-12-18T14:53:36+00:00","og_image":[{"width":1072,"height":1312,"url":"https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2023\/02\/\u56fe\u7247-14.png","type":"image\/png"}],"author":"leo gu","twitter_card":"summary_large_image","twitter_misc":{"Written by":"leo gu","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Organization","@id":"https:\/\/www.dpriver.com\/blog\/#organization","name":"SQL and Data Blog","url":"https:\/\/www.dpriver.com\/blog\/","sameAs":[],"logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dpriver.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2022\/07\/sqlpp-character.png","contentUrl":"https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2022\/07\/sqlpp-character.png","width":251,"height":72,"caption":"SQL and Data Blog"},"image":{"@id":"https:\/\/www.dpriver.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"WebSite","@id":"https:\/\/www.dpriver.com\/blog\/#website","url":"https:\/\/www.dpriver.com\/blog\/","name":"SQL and Data Blog","description":"SQL related blog for database professional","publisher":{"@id":"https:\/\/www.dpriver.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dpriver.com\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.dpriver.com\/blog\/convert-sql-into-e-r-diagram-with-sqlflow\/","url":"https:\/\/www.dpriver.com\/blog\/convert-sql-into-e-r-diagram-with-sqlflow\/","name":"Convert SQL into E-R Diagram with SQLFlow","isPartOf":{"@id":"https:\/\/www.dpriver.com\/blog\/#website"},"datePublished":"2023-02-28T13:00:04+00:00","dateModified":"2023-12-18T14:53:36+00:00","description":"Convert SQL into E-R Diagram with SQLFlow, from SQL to ER Diagram","breadcrumb":{"@id":"https:\/\/www.dpriver.com\/blog\/convert-sql-into-e-r-diagram-with-sqlflow\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dpriver.com\/blog\/convert-sql-into-e-r-diagram-with-sqlflow\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dpriver.com\/blog\/convert-sql-into-e-r-diagram-with-sqlflow\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.dpriver.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Convert SQL into E-R Diagram with SQLFlow"}]},{"@type":"Article","@id":"https:\/\/www.dpriver.com\/blog\/convert-sql-into-e-r-diagram-with-sqlflow\/#article","isPartOf":{"@id":"https:\/\/www.dpriver.com\/blog\/convert-sql-into-e-r-diagram-with-sqlflow\/"},"author":{"name":"leo gu","@id":"https:\/\/www.dpriver.com\/blog\/#\/schema\/person\/9e80d249b6da4e572bd8590b0789bc14"},"headline":"Convert SQL into E-R Diagram with SQLFlow","datePublished":"2023-02-28T13:00:04+00:00","dateModified":"2023-12-18T14:53:36+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dpriver.com\/blog\/convert-sql-into-e-r-diagram-with-sqlflow\/"},"wordCount":541,"publisher":{"@id":"https:\/\/www.dpriver.com\/blog\/#organization"},"articleSection":["Data Governance","SQLFlow"],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dpriver.com\/blog\/#\/schema\/person\/9e80d249b6da4e572bd8590b0789bc14","name":"leo gu","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dpriver.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/24976e2e4ca7dd476652bb26bd09392b?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/24976e2e4ca7dd476652bb26bd09392b?s=96&d=mm&r=g","caption":"leo gu"},"url":"https:\/\/www.dpriver.com\/blog\/author\/guyuanhao\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/posts\/2696"}],"collection":[{"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/comments?post=2696"}],"version-history":[{"count":10,"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/posts\/2696\/revisions"}],"predecessor-version":[{"id":2988,"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/posts\/2696\/revisions\/2988"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/media\/2710"}],"wp:attachment":[{"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/media?parent=2696"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/categories?post=2696"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/tags?post=2696"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}