The CREATE DOMAIN statement names a new Domain and defines the Domain's set of valid values. The required syntax for the CREATE DOMAIN statement is: CREATE DOMAIN <Domain name> [ AS ] <data type>

    [ DEFAULT default value ]
    [ <Domain Constraint> list ]
    [ COLLATE <Collation name> ]
  <Domain constraint> list::=
  <Domain Constraint> [ <Domain Constraint>... ]
     <Domain constraint> ::=
     [ CONSTRAINT <Constraint name> ]
     Constraint_type
     [ <constraint attributes> ]

CREATE DOMAIN defines a new Domain: a named set of valid data values that can be used — somewhat like a macro — to replace the <data type> specification in subsequent <Column definition>s. The <Domain name> identifies the Domain and the Schema to which it belongs. A <Domain name> that includes an explicit <Schema name> qualifier belongs to the Schema named. A <Domain name> that does not include an explicit <Schema name> qualifier belongs to the SQL-session default Schema. The <Domain name> must be unique (for all Domains and UDTs) within the Schema that owns it.

sandeep vishwakarma from deoria UP

Start a discussion about improving the Attribute domain page

Start a discussion