Toad World® Forums

Can data type in ERD be edited?


#1

We use Oracle but don’t want the data type showing as Varchar2. We want it to be non-proprietary, i.e., Varchar. Is there a way to edit what the ERD shows, rather than the actual data type in the table?


#2

Hello,

If we understand well, you want to show Varchar instead of Varchar2 in tables on WS(it’s just a question of display).

In this case, we can offer you the following workaround.

  1. Create a domain in your model:
    Model | Domains | Add | Apply | Edit.

  2. Edit the domain this way:
    Name/Caption - write ‘Varchar’.
    Data type - select ‘Varchar2’.

  3. Edit each attribute and instead of data type, select the domain for the attribute.
    Note: If your model is large and you want to assign the domain to the attributes with Varchar2 data type at one jump, please let us know. We will create a script for you (you will execute the script in Scripting Window then).

  4. Right-click the WS | Workspace Format | Entity tab | clear the Display Dictionary Types as Data Types checkbox.

-> Now you should see the attributes on WS with ‘Varchar’ only.

Note: When you generate SQL script for the model, Varchar2 will be generated in the script. This workaround is just for the display purpose.

If you have any questions, please write us back. Thanks.

Regards,

Vladka + TDM Team