Talk:Attribute domain
 | This article is rated Stub-class on Wikipedia's content assessment scale. It is of interest to the following WikiProjects: | ||||||||||
| |||||||||||
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