ALL_TAB_IDENTITY_COLS
ALL_TAB_IDENTITY_COLS describes all table identity columns.
Related Views
-
DBA_TAB_IDENTITY_COLSdescribes all table identity columns. -
USER_TAB_IDENTITY_COLSdescribes all table identity columns. This view does not display theOWNERcolumn.
| 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 |
See Also:
See Also:
-
The ALTER TABLE statement in Oracle AI Database SQL Language Reference for more information about creating an identity column
-
The CREATE TABLE statements in Oracle AI Database SQL Language Reference for more information about creating an identity column