Display Default Values

Display of Default Values

Default values can be displayed in the column COLUMN_DEFAULT of system tables EXA_ALL_COLUMNS, EXA_DBA_COLUMNS, and EXA_USER_COLUMNS.

Example

CREATE TABLE t (i DECIMAL DEFAULT 3+4);
SELECT column_default FROM exa_all_columns
            WHERE column_table='t'
            AND   column_name='i';