Define Identity Columns on SQL Modeler 23
I always used JDeveloper for Database Design, but this project doesn't have a new release since 2017 and it's last supported Oracle Version was 12c. Now I have to design a data Base for Oracle 19c so I tried SQL Developer Data Modeler and I've had some problems adapting to this new tool. I have a table with ID and I want this to be type number and generated always as identity, something like this CREATE TABLE my_table ( id_my_table NUMBER GENERATED ALWAYS AS IDENTITY ( START WITH 1 NOCACHE ORDER ) NOT NULL, name VARCHAR2(100) NOT NULL, .... Here are the steps to achieve this. First, let's make sure that the diagram is using a recent version of Oracle, right click on your model and select properties And make sure the RDBMS values are set to Oracle Database 12c or greater Go to Tools > Preferences, then go to Data modeler > Model and check the db Version Now, got to Data Modeler / Model / Physical and change " Default I...