ALL_TAB_IDENTITY_COLS describes all table identity columns.
Related Views
DBA_TAB_IDENTITY_COLS describes all table identity columns.
USER_TAB_IDENTITY_COLS describes all table identity columns. This view does not display the OWNER column.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
|
Owner of the table |
|
|
|
|
Name of the table |
|
|
|
|
Name of the identity column |
|
|
|
Generation type of the identity column. Possible values are |
|
|
|
|
|
Name of the sequence associated with the identity column |
|
|
|
Options for the identity column sequence generator |
See Also:
See Also:
The ALTER TABLE statement in Oracle Database SQL Language Reference for more information about creating an identity column
The CREATE TABLE statements in Oracle Database SQL Language Reference for more information about creating an identity column
Oracle Database Migration Guide for more information about migrating third-party databases with identity columns to Oracle Database
This column is available starting with Oracle Database 12c Release 1 (12.1.0.2).