从ORACLE 19C列中删除标识

Question

是否有办法从Oracle db19c的列中删除标识规范?在sys表上的某种脚本?

Answer 1

就像你说的-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 "drop identity")