Display of Identity Columns

Identity columns can be listed using the column COLUMN_IDENTITY of the system tables EXA_ALL_COLUMNS, EXA_DBA_COLUMNS, and EXA_USER_COLUMNS. The entry of the identity column is the last generated number.

Example

CREATE TABLE t (id INTEGER IDENTITY 30);
SELECT column_identity FROM exa_all_columns
             WHERE column_table='T'
             AND column_name='ID';