How to set Auto increment Integer in Oracle Data Modeler

119 Views Asked by At

I am looking for an option to select or add to make the primary key which is an Integer generate itself, adding to the previous value of 1. I don't need code SQL , just where can I do this in Oracle Data Modeler. Version 23.1.0.087

2

There are 2 best solutions below

6
Littlefoot On BEST ANSWER

Open column's properties and set auto increment property ON:

enter image description here

0
d r On

You can add it in SQL Developer. Open your table - click on Columns tab - click on pencil icon - add column (ID) - click on Identity Column tab and define your ID. When finished - OK enter image description here