# \#database

**URL:** https://forums.visual-paradigm.com/tag/database/6.md

[Latest](https://forums.visual-paradigm.com/latest.md) · [Categories](https://forums.visual-paradigm.com/categories.md) · [Tags](https://forums.visual-paradigm.com/tags.md)

---

## [Generate DDL for BigQuery](https://forums.visual-paradigm.com/t/generate-ddl-for-bigquery/22630)

<div class="topic-metadata">

**Author:** [@meras](https://forums.visual-paradigm.com/u/meras)\
**Replies:** 2\
**Last updated:** [November 12, 2026, 12:57pm UTC](https://forums.visual-paradigm.com/t/generate-ddl-for-bigquery/22630 "2026-11-12T12:57:15Z")

</div>

Hi, How I can generate DDL from my diagrams with dialect and data types compatible with Google BigQuery ?

---

## [How to change from role when synchronizing to class diagram?](https://forums.visual-paradigm.com/t/how-to-change-from-role-when-synchronizing-to-class-diagram/22755)

<div class="topic-metadata">

**Author:** [@Yal](https://forums.visual-paradigm.com/u/Yal)\
**Replies:** 1\
**Last updated:** [August 15, 2026, 10:12am UTC](https://forums.visual-paradigm.com/t/how-to-change-from-role-when-synchronizing-to-class-diagram/22755 "2026-08-15T10:12:10Z")

</div>

Hey guys. I am using Visual Paradigm Enterprise 18.1 Evaluation Version and want to visualize a database as a uml class diagram. For that I used “Reverse DDL” to generate an ERD and then “Synchronize to Class Diagram” …

---

## [Version of Hibernate & Spring Datasource Support](https://forums.visual-paradigm.com/t/version-of-hibernate-spring-datasource-support/16791)

<div class="topic-metadata">

**Author:** [@Grip\_In](https://forums.visual-paradigm.com/u/Grip_In)\
**Replies:** 8\
**Last updated:** [January 21, 2026, 2:58am UTC](https://forums.visual-paradigm.com/t/version-of-hibernate-spring-datasource-support/16791 "2026-01-21T02:58:44Z")

</div>

Hello, Which version of hibernate you use on latest ORM.jar? Do you support using Spring Integration to manage persistent manager instead of doing Persistent manager as Separate singleton, we wanted to use spring datas…

---

## [Using Barker's notation in ERDs](https://forums.visual-paradigm.com/t/using-barkers-notation-in-erds/21176)

<div class="topic-metadata">

**Author:** [@DerekL0576](https://forums.visual-paradigm.com/u/DerekL0576)\
**Replies:** 1\
**Last updated:** [October 14, 2024, 6:58am UTC](https://forums.visual-paradigm.com/t/using-barkers-notation-in-erds/21176 "2024-10-14T06:58:31Z")

</div>

Is there a way that I can create custom connectors to use Barker’s notation with ERDs? entitymodelling.org

---

## [Cardinality problem when synchronizing a Logical ERD to a Physical ERD](https://forums.visual-paradigm.com/t/cardinality-problem-when-synchronizing-a-logical-erd-to-a-physical-erd/20984)

<div class="topic-metadata">

**Author:** [@hooijdonk.c](https://forums.visual-paradigm.com/u/hooijdonk.c)\
**Replies:** 1\
**Last updated:** [June 27, 2024, 7:35am UTC](https://forums.visual-paradigm.com/t/cardinality-problem-when-synchronizing-a-logical-erd-to-a-physical-erd/20984 "2024-06-27T07:35:12Z")

</div>

I have a problem regarding the ‘From-end cardinality’ when synchronising a Logical ERD to a Physical ERD. (Right click in Logical diagram - Utilities - Synchronize to Physical Model ERD) Logical model: 'From-end cardina…

---

## [How to hide/show columns in ERD](https://forums.visual-paradigm.com/t/how-to-hide-show-columns-in-erd/20964)

<div class="topic-metadata">

**Author:** [@ahuntertate\_cke](https://forums.visual-paradigm.com/u/ahuntertate_cke)\
**Replies:** 5\
**Last updated:** [June 21, 2024, 2:44pm UTC](https://forums.visual-paradigm.com/t/how-to-hide-show-columns-in-erd/20964 "2024-06-21T14:44:20Z")

</div>

How to hide/show entity columns in an ERD. This option seems to have been removed. I would like to se the option to Only show Key columns like every other data modeling tool. I have Entities with 100+ attributes tha…

---

## [Transforming Object Names in ERD to Database Model](https://forums.visual-paradigm.com/t/transforming-object-names-in-erd-to-database-model/18263)

<div class="topic-metadata">

**Author:** [@EbenvR](https://forums.visual-paradigm.com/u/EbenvR)\
**Replies:** 0\
**Last updated:** [November 3, 2023, 9:49am UTC](https://forums.visual-paradigm.com/t/transforming-object-names-in-erd-to-database-model/18263 "2023-11-03T09:49:24Z")

</div>

Hi, I’ve found a place where abbreviations can be used when transforming an ERD to a physical database model. But I cannot find anywhere to specify case transformations, i.e. transform from Mixed Case Logical Names with …

---

## [SQL Server Functions Default Values ​​(ERD)](https://forums.visual-paradigm.com/t/sql-server-functions-default-values-erd/18220)

<div class="topic-metadata">

**Author:** [@Danilo\_Collado](https://forums.visual-paradigm.com/u/Danilo_Collado)\
**Replies:** 1\
**Last updated:** [October 12, 2023, 9:17am UTC](https://forums.visual-paradigm.com/t/sql-server-functions-default-values-erd/18220 "2023-10-12T09:17:46Z")

</div>

When I add a default value to a field in my table through VP, when generating the script, it generates it as a string, however I would like it to generate it with a function, as it is an SQL function, just like the GETDA…

---

## [Can we create a view by merging tables](https://forums.visual-paradigm.com/t/can-we-create-a-view-by-merging-tables/18148)

<div class="topic-metadata">

**Author:** [@Luke\_Mao](https://forums.visual-paradigm.com/u/Luke_Mao)\
**Replies:** 1\
**Last updated:** [July 20, 2023, 4:15am UTC](https://forums.visual-paradigm.com/t/can-we-create-a-view-by-merging-tables/18148 "2023-07-20T04:15:33Z")

</div>

Other than join tables, can we also create a view by merging tables.

---

## [What is the big 'M' for at top left of a table](https://forums.visual-paradigm.com/t/what-is-the-big-m-for-at-top-left-of-a-table/18152)

<div class="topic-metadata">

**Author:** [@Luke\_Mao](https://forums.visual-paradigm.com/u/Luke_Mao)\
**Replies:** 1\
**Last updated:** [July 19, 2023, 9:13am UTC](https://forums.visual-paradigm.com/t/what-is-the-big-m-for-at-top-left-of-a-table/18152 "2023-07-19T09:13:38Z")

</div>

I can see a copital ‘M’ on top left of the table . what is that ‘M’ stand for?

---

## [Virtual foreign key](https://forums.visual-paradigm.com/t/virtual-foreign-key/17930)

<div class="topic-metadata">

**Author:** [@myatmin](https://forums.visual-paradigm.com/u/myatmin)\
**Replies:** 1\
**Last updated:** [March 24, 2023, 3:31am UTC](https://forums.visual-paradigm.com/t/virtual-foreign-key/17930 "2023-03-24T03:31:23Z")

</div>

Does VP support virtual foreign key feature or any equivalent?

---

## [Creating Custom Object inside class](https://forums.visual-paradigm.com/t/creating-custom-object-inside-class/17850)

<div class="topic-metadata">

**Author:** [@Ahmed\_El-banna](https://forums.visual-paradigm.com/u/Ahmed_El-banna)\
**Replies:** 1\
**Last updated:** [January 30, 2023, 7:06am UTC](https://forums.visual-paradigm.com/t/creating-custom-object-inside-class/17850 "2023-01-30T07:06:37Z")

</div>

Dears, i have a situation where i have TimePeriod object which consists of two attributes StartDate, EndDate of type DateTime. i need to use TimePeriod as attribute type in my classes as below however when I try to …

---

## [Erd check constraint](https://forums.visual-paradigm.com/t/erd-check-constraint/17796)

<div class="topic-metadata">

**Author:** [@Rogerio\_Oliveira](https://forums.visual-paradigm.com/u/Rogerio_Oliveira)\
**Replies:** 1\
**Last updated:** [December 5, 2022, 6:21am UTC](https://forums.visual-paradigm.com/t/erd-check-constraint/17796 "2022-12-05T06:21:20Z")

</div>

Hello! I’m trying to add a Check constraint just like CHECK column IN (‘string’1’, ‘string2’). When I open the ERD Physical Model and in Column specification there’s a field named “Check Constraint”. I have tried a lot o…

---

## [DDL reverse not importing views](https://forums.visual-paradigm.com/t/ddl-reverse-not-importing-views/17727)

<div class="topic-metadata">

**Author:** [@fniehaus](https://forums.visual-paradigm.com/u/fniehaus)\
**Replies:** 2\
**Last updated:** [October 24, 2022, 5:36am UTC](https://forums.visual-paradigm.com/t/ddl-reverse-not-importing-views/17727 "2022-10-24T05:36:30Z")

</div>

When reversing a DDL dump from MSSQL Server, views are not imported even though their regular base tables are. Is this not supported in general or is there anything I can adjust so importing views is possible? There are …

---

## [Find Master view of an Entity (ERDs)](https://forums.visual-paradigm.com/t/find-master-view-of-an-entity-erds/17670)

<div class="topic-metadata">

**Author:** [@winojones](https://forums.visual-paradigm.com/u/winojones)\
**Replies:** 2\
**Last updated:** [August 30, 2022, 1:03pm UTC](https://forums.visual-paradigm.com/t/find-master-view-of-an-entity-erds/17670 "2022-08-30T13:03:06Z")

</div>

Would like a feature where the diagram containing the Master View of an entity can be found and displayed.

---

## [Navigating Diagrams in Viewer](https://forums.visual-paradigm.com/t/navigating-diagrams-in-viewer/17669)

<div class="topic-metadata">

**Author:** [@winojones](https://forums.visual-paradigm.com/u/winojones)\
**Replies:** 1\
**Last updated:** [August 30, 2022, 5:41am UTC](https://forums.visual-paradigm.com/t/navigating-diagrams-in-viewer/17669 "2022-08-30T05:41:20Z")

</div>

The ability to navigate to the different views (diagrams) that have a particular entity does not exist in the Viewer edition. Please add it. While create an ERD, I can right-click on an entity, hover over “Related Ele…

---

## [Removing a transition Conceptual to Logical to Physical ERD](https://forums.visual-paradigm.com/t/removing-a-transition-conceptual-to-logical-to-physical-erd/17629)

<div class="topic-metadata">

**Author:** [@Geoff\_Fane\_Home](https://forums.visual-paradigm.com/u/Geoff_Fane_Home)\
**Replies:** 1\
**Last updated:** [July 15, 2022, 9:28am UTC](https://forums.visual-paradigm.com/t/removing-a-transition-conceptual-to-logical-to-physical-erd/17629 "2022-07-15T09:28:09Z")

</div>

Hi Guys following the guidance on Remove a transition found here Model Transitor (Diagram Element and Model Element). Doesn’t appear to work, when I right click - Utilities and Synchronise from my Conceptual ERD to my L…

---

## [Reverse DB2 database not giving any tables even though connection successfull!](https://forums.visual-paradigm.com/t/reverse-db2-database-not-giving-any-tables-even-though-connection-successfull/17560)

<div class="topic-metadata">

**Author:** [@sudeepep](https://forums.visual-paradigm.com/u/sudeepep)\
**Replies:** 1\
**Last updated:** [May 16, 2022, 3:18am UTC](https://forums.visual-paradigm.com/t/reverse-db2-database-not-giving-any-tables-even-though-connection-successfull/17560 "2022-05-16T03:18:30Z")

</div>

Dear All, I was trying to reverse database using visual paradigm for my DB2 database however after connection is successful if I click next it does not bring any tables for the database. Can anyone suggest me how to res…

---

## [Quality metrics in Entity Relationship Models](https://forums.visual-paradigm.com/t/quality-metrics-in-entity-relationship-models/17051)

<div class="topic-metadata">

**Author:** [@Asa](https://forums.visual-paradigm.com/u/Asa)\
**Replies:** 12\
**Last updated:** [December 24, 2021, 1:06pm UTC](https://forums.visual-paradigm.com/t/quality-metrics-in-entity-relationship-models/17051 "2021-12-24T13:06:51Z")

</div>

Hi, Is there any feature in visual paradigm to measure the complexity (even metrics like no of entities, no of attributes etc) of an ER model? Thanks !

---

## [Unable to import redshift erd from ddl](https://forums.visual-paradigm.com/t/unable-to-import-redshift-erd-from-ddl/17199)

<div class="topic-metadata">

**Author:** [@jolly](https://forums.visual-paradigm.com/u/jolly)\
**Replies:** 1\
**Last updated:** [December 8, 2021, 5:34am UTC](https://forums.visual-paradigm.com/t/unable-to-import-redshift-erd-from-ddl/17199 "2021-12-08T05:34:10Z")

</div>

I get this error when I try to load redshift database from ddl. Also, there is no option for Redshift, so i chose postgreSQL. Parse error at line 15, column 32. Encountered: ENCODE The ddl was generated with help of t…

---

## [ID column sample data is not being included when I generate test data file](https://forums.visual-paradigm.com/t/id-column-sample-data-is-not-being-included-when-i-generate-test-data-file/17069)

<div class="topic-metadata">

**Author:** [@DG1](https://forums.visual-paradigm.com/u/DG1)\
**Replies:** 2\
**Last updated:** [October 19, 2021, 3:46am UTC](https://forums.visual-paradigm.com/t/id-column-sample-data-is-not-being-included-when-i-generate-test-data-file/17069 "2021-10-19T03:46:07Z")

</div>

I have defined a bunch of tables for a postgres db. I have put sample data in them. I have generated ddl file to create the tables and it includes the insert statements for the sample data. However those inserts don’t i…

---

## [How to create sub groupings of entities in ERD](https://forums.visual-paradigm.com/t/how-to-create-sub-groupings-of-entities-in-erd/17055)

<div class="topic-metadata">

**Author:** [@DG1](https://forums.visual-paradigm.com/u/DG1)\
**Replies:** 3\
**Last updated:** [October 7, 2021, 2:46am UTC](https://forums.visual-paradigm.com/t/how-to-create-sub-groupings-of-entities-in-erd/17055 "2021-10-07T02:46:46Z")

</div>

I have just imported over 100 table definitions from existing system that has no documentation. It’s impossible for someone to get a feel for something that large. I’d like to create separate groupings. E.g. Customer …

---

## [ERD Sub-Diagrams after a fashion](https://forums.visual-paradigm.com/t/erd-sub-diagrams-after-a-fashion/16705)

<div class="topic-metadata">

**Author:** [@Mike\_Craig](https://forums.visual-paradigm.com/u/Mike_Craig)\
**Replies:** 4\
**Last updated:** [September 23, 2021, 12:37am UTC](https://forums.visual-paradigm.com/t/erd-sub-diagrams-after-a-fashion/16705 "2021-09-23T00:37:52Z")

</div>

I can sort of get this to work but it still seems like magic so I don’t think I’m doing this the right way and the questions I ask the world thus far don’t seem to get me quite where I want. Using other diagram tools fo…

---

## [Deletion instruction at the beginning of SQL-DDL code for triggers (DROP TRIGGER)](https://forums.visual-paradigm.com/t/deletion-instruction-at-the-beginning-of-sql-ddl-code-for-triggers-drop-trigger/17015)

<div class="topic-metadata">

**Author:** [@ArberSmajli](https://forums.visual-paradigm.com/u/ArberSmajli)\
**Replies:** 1\
**Last updated:** [September 8, 2021, 2:37am UTC](https://forums.visual-paradigm.com/t/deletion-instruction-at-the-beginning-of-sql-ddl-code-for-triggers-drop-trigger/17015 "2021-09-08T02:37:19Z")

</div>

Good evening ladies and gentlemen, I’m a student and I’m currently finishing my bachelor’s work on the improvement of a plugin on VisualParadigm. I’m writing to you to get some information because when I try to generat…

---

## [Glossary Export and Import](https://forums.visual-paradigm.com/t/glossary-export-and-import/16983)

<div class="topic-metadata">

**Author:** [@TheProfessor](https://forums.visual-paradigm.com/u/TheProfessor)\
**Replies:** 1\
**Last updated:** [August 24, 2021, 11:37am UTC](https://forums.visual-paradigm.com/t/glossary-export-and-import/16983 "2021-08-24T11:37:07Z")

</div>

I am seeking to determine if Visual Paradigm can be used as the core of an Enterprise Glossary. This requires the ability to share the data definitions between projects to enable agile and quick design with full enterpri…

---

## [Class/Entities name collision](https://forums.visual-paradigm.com/t/class-entities-name-collision/16688)

<div class="topic-metadata">

**Author:** [@Jerzy\_Stachera](https://forums.visual-paradigm.com/u/Jerzy_Stachera)\
**Replies:** 1\
**Last updated:** [March 24, 2021, 1:07am UTC](https://forums.visual-paradigm.com/t/class-entities-name-collision/16688 "2021-03-24T01:07:28Z")

</div>

Hi. In single project i have few class diagrams, how to separate them on class name level. Since when I try to create class with the same name as it is in other class diagram then It shows me warning ‘change to aux view…

---

## [VP Online ver 16.1 - license problem](https://forums.visual-paradigm.com/t/vp-online-ver-16-1-license-problem/16272)

<div class="topic-metadata">

**Author:** [@MariusMi](https://forums.visual-paradigm.com/u/MariusMi)\
**Replies:** 11\
**Last updated:** [February 17, 2021, 1:17am UTC](https://forums.visual-paradigm.com/t/vp-online-ver-16-1-license-problem/16272 "2021-02-17T01:17:39Z")

</div>

Hello again :slight\_smile: We have a little issue. After upgrading from 15.2 to 16.1, in the online environment we cannot enter some types of diagrams. The message about the need to upgrade and the label advance are di…

---

## [ERD model validation](https://forums.visual-paradigm.com/t/erd-model-validation/16604)

<div class="topic-metadata">

**Author:** [@Jerzy\_Stachera](https://forums.visual-paradigm.com/u/Jerzy_Stachera)\
**Replies:** 1\
**Last updated:** [February 8, 2021, 3:58am UTC](https://forums.visual-paradigm.com/t/erd-model-validation/16604 "2021-02-08T03:58:21Z")

</div>

Are there any functions to validate ERD diagram, eg. missing indices on foreign keys, circular dependencies, etc … BR, Jurek

---

## [Move data between databases](https://forums.visual-paradigm.com/t/move-data-between-databases/16591)

<div class="topic-metadata">

**Author:** [@Jerzy\_Stachera](https://forums.visual-paradigm.com/u/Jerzy_Stachera)\
**Replies:** 3\
**Last updated:** [February 8, 2021, 3:08am UTC](https://forums.visual-paradigm.com/t/move-data-between-databases/16591 "2021-02-08T03:08:35Z")

</div>

Hi, Is there any way to generate SQL from VP which will allow to send data from one ERD diagram to the other (different schema). I mean that having to different ERD diagrams, there is an option to create mapping from one…

---

## [Rest API from ERD diagram](https://forums.visual-paradigm.com/t/rest-api-from-erd-diagram/16605)

<div class="topic-metadata">

**Author:** [@Jerzy\_Stachera](https://forums.visual-paradigm.com/u/Jerzy_Stachera)\
**Replies:** 1\
**Last updated:** [February 6, 2021, 2:04pm UTC](https://forums.visual-paradigm.com/t/rest-api-from-erd-diagram/16605 "2021-02-06T14:04:04Z")

</div>

Hi, Is there any way to generate REST API from ERD diagram? BR, Jurek

[Next page](https://forums.visual-paradigm.com/tag/database/6.md?match_all_tags=true&page=1&tags%5B%5D=database)
