By specifying a DEFAULT predicate, you can check whether a column contains the default value defined for this column.

column spec, comp op

A DEFAULT specification must be made for the specified column. This can be done in the following SQL statements:

• CREATE TABLE statement
• ALTER TABLE statement

If the column contains the NULL value (see data type), <column spec> <comp op> DEFAULT is undefined.

The rules for comparing values or value lists, as defined under comparison predicate, apply here.