Search code examples
sqloracle-databasedatabase-administrationoracle19c

DROP IDENTITY FROM COLUMN ORACLE 19C

Is there any way to drop identity specification from a column in Oracle db19c? Some sort of script on sys tables?

Solution

  • Just as you said it - drop identity.

    SQL> create table test
  2    (id number generated always as identity);

Table created.

SQL> alter table test modify id drop identity;

Table altered.

SQL>

    Oracle 19c ALTER TABLE (search for "drop identity").