Firebird Documentation IndexFirebird 1.5 Language Ref. UpdateDDL statements → CREATE DOMAIN
Firebird Home Firebird Home Prev: CREATE DATABASEFirebird Documentation IndexUp: DDL statementsNext: CREATE GENERATOR

CREATE DOMAIN

Context variables as defaults

Available in: DSQL, ESQL

Context variables as defaults

Changed in: IB

Description: Any context variable that is assignment-compatible to the new 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: 

create domain DDate as
  date
  default current_date
  not null
Prev: CREATE DATABASEFirebird Documentation IndexUp: DDL statementsNext: CREATE GENERATOR
Firebird Documentation IndexFirebird 1.5 Language Ref. UpdateDDL statements → CREATE DOMAIN