CREATE DOMAIN

<< DOMAIN | FB 2.5 Language Reference | ALTER DOMAIN >>
<< ALTER DATABASE | FB 2.1 Language Reference | ALTER DOMAIN>>
<< CREATE DATABASE | FB 2.0 Language Reference | CREATE EXCEPTION >>

CREATE DOMAIN

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

See also:
Create a domain
ALTER DOMAIN
ALTER TABLE
CREATE TABLE
DROP DOMAIN
DDL - Data Definition Language

back to top of page
<< DOMAIN | FB 2.5 Language Reference | ALTER DOMAIN >>
<< ALTER DATABASE | FB 2.1 Language Reference | ALTER DOMAIN>>
<< CREATE DATABASE | FB 2.0 Language Reference | CREATE EXCEPTION >>