4

Using Enterprise Architect version 13.0.1309, I'm designing a database model to be used with Oracle 12c. I want to generate a DDL script from my model that uses the "new" IDENTITY column type instead of the explicitly created sequences and triggers.

Example:

CREATE TABLE identity_test_tab (
  id          NUMBER GENERATED BY DEFAULT AS IDENTITY,
  description VARCHAR2(30)
);

However, I either can't find the option in EA or it is not supported. Which one is it?

Sentry
  • 4,102
  • 2
  • 30
  • 38
  • did you find any solution for this problem? – Muka Oct 11 '21 at 19:45
  • @Muka I honestly can't remember anymore. Changes jobs twice since then. But if I had found a solution around that time, I would've posted it here. So probably not :( – Sentry Oct 15 '21 at 09:36

0 Answers0