Search notes:

Oracle: Using an identity column silently creates a sequence

Behind the scenes, Oracle creates a sequence for identity columns.
create table tq84_ident_test (
   id   integer generated always as identity primary key,
   val  number(6,2)
);

select
   object_name,
   (sysdate - created) * 24*60*60 created_secs_ago,
   user_objects.*
from
   user_objects
where
   object_type = 'SEQUENCE'
order by
   created desc;
   
drop table tq84_ident_test;
In Oracle's free edition of 23c, the sequence is not dropped when the table is dropped.

Index