Firebird Documentation Index → Firebird 2.0 Language Ref. Update → DDL statements → ALTER DOMAIN
Firebird Home Firebird Home Prev: ALTER DATABASEFirebird Documentation IndexUp: DDL statementsNext: ALTER EXTERNAL FUNCTION

ALTER DOMAIN

SET DEFAULT to any context variable

Available in: DSQL, ESQL

SET DEFAULT to any context variable

Changed in: IB

Description: Any context variable that is assignment-compatible to the domain's datatype can be used as a default. This was already the case in InterBase 6, but the Language Reference only mentioned USER.

Example: 

alter domain DDate
  set default current_date
Prev: ALTER DATABASEFirebird Documentation IndexUp: DDL statementsNext: ALTER EXTERNAL FUNCTION
Firebird Documentation Index → Firebird 2.0 Language Ref. Update → DDL statements → ALTER DOMAIN