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
Start a discussion about improving the Attribute domain page
Talk pages are where people discuss how to make content on Wikipedia the best that it can be. You can use this page to start a discussion with others about how to improve the "Attribute domain" page.