Below are the 3 views that will list the tables with identity columns in Oracle:
PS: I know this post does not make any sense, but sometimes I try to quickly find those table names in Google and for whatever reason, Google Indexer can't find proper websites. So I make this post to help myself.
The table structure:
| Column | Datatype | NULL | Description |
|---|---|---|---|
OWNER |
VARCHAR2(128) |
NOT NULL |
Owner of the table |
TABLE_NAME |
VARCHAR2(128) |
NOT NULL |
Name of the table |
COLUMN_NAME |
VARCHAR2(128) |
NOT NULL |
Name of the identity column |
GENERATION_TYPE |
VARCHAR2(10) |
Generation type of the identity column. Possible values are ALWAYS or BY DEFAULT. |
|
SEQUENCE_NAME |
VARCHAR2(128) |
NOT NULL |
Name of the sequence associated with the identity column |
IDENTITY_OPTIONS |
VARCHAR2(298) |
Options for the identity column sequence generator |
