1. Vertabelo
  2. Questions
0
Résolu

oracle identity ?

Ugo Peltier il y a 4 ans • mis à jour par Rafał Strzaliński (Senior Engineer) il y a 4 ans • 1

Hi,


Starting v12c of Oracle, we can add identity column to tables, here is an explanation:

https://www.oracletutorial.com/oracle-basics/oracle-identity-column/#:~:text=Introduction%20to%20Oracle%20identity%20column,the%20surrogate%20primary%20key%20column.

How can I add this to the ERD definition in vertabelo ?

+1
Résolu
Rafał Strzaliński (Senior Engineer) il y a 4 ans

These is no direct support in the UI. 

According to the documentation identity can be added by alter table statement. 

https://docs.oracle.com/en/database/oracle/oracle-database/12.2/sqlrf/ALTER-TABLE.html#GUID-552E7373-BF93-477D-9DA3-B2C9386F2877


You may put an alter table statement into  "Post creating table"  (see "Additional SQL Script"  table details section)

Service d'assistance aux clients par UserEcho