Incorrectly generate DDL for column default value

_Dima_

Hello, it seems that Data Modeler does incorrectly generate DDL for column default value.

I use SYSDATE as default value for column CREATED_AT. Data Modeler generates DDL with SYSDATE in lowercase. Thus I end up forever not synchronized model with actual schema, as in my model used SYSDATE and in schema 'sysdate'.

Use Data Modeler 19.4, Oracle Base 12C, Oracle Linux 7.7

Please see screenshots

Did I make something wrong?

Dave Schleis

Hello,

No, you did nothing wrong. I believe that the issue here is simply a preference setting.

SQL Developer Data Modeler is amazingly customizable. There are preference settings at the application level, the design level and the model level.

At the application level, one of the things you can set is what you want SDDM to pay attention to when comparing a relational model to a database instance.

As you can see in the image below, one of these comparisons is case sensitivity.

From the help:

Case Sensitive Names in Compare Functionality: Controls whether the letter case in object names should be considered when comparing two objects

I suspect that unchecking this comparison will make it easier for you to keep things in synch.

Hope this helps

--dave

Dave Schleis

Hello,

No, you did nothing wrong. I believe that the issue here is simply a preference setting.

SQL Developer Data Modeler is amazingly customizable. There are preference settings at the application level, the design level and the model level.

At the application level, one of the things you can set is what you want SDDM to pay attention to when comparing a relational model to a database instance.

As you can see in the image below, one of these comparisons is case sensitivity.

From the help:

Case Sensitive Names in Compare Functionality: Controls whether the letter case in object names should be considered when comparing two objects

I suspect that unchecking this comparison will make it easier for you to keep things in synch.

Hope this helps

--dave