How to create calculated column in ERD

The calculated column in database (also call generated column in some databases) allow users to define an expression for calculating values by using data from other columns. This saving user effort to obtain the values in desired form by let the DBMS handling it. In Visual Paradigm you can define the expression for calculated column by using the User Type. To create calculated column:

  1. Right click on the column and select Open Specification form popup menu.

    Open specification dialog of the calculated column

    Open specification dialog of the calculated column

  2. Enter the definition of the calculation column in the User type.

    Define expression for the calculated column

    Define expression for the calculated column

Once the calculation being defined it will be reflect in the generated DDL.

Generated DDL include the expression of the calculated column

Generated DDL include the expression of the calculated column

Related Know-how

Related Link

0 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply