1. Vertabelo
  2. Pytania
0
Z odpowiedzią

oracle identity ?

Ugo Peltier 4 lat temu • Ostatnio zmodyfikowane przez Rafał Strzaliński (Senior Engineer) 4 lat temu • 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
Z odpowiedzią
Rafał Strzaliński (Senior Engineer) 4 lat temu

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)

Customer support service by UserEcho