CREATE DOMAIN - История изменений

SYSDBA в 11:01, 18 июня 2014

2014-06-18T11:01:05Z

SYSDBA: Содержимое страницы заменено на «[http://firebirdsql.su/doku.php?id=create_domain CREATE DOMAIN] Category:База данных»

2014-06-18T11:00:19Z

Содержимое страницы заменено на «[http://firebirdsql.su/doku.php?id=create_domain CREATE DOMAIN] Category:База данных»

Flake в 07:59, 7 октября 2009

2009-10-07T07:59:37Z

SYSDBA в 10:25, 2 марта 2007

2007-03-02T10:25:01Z

Новая страница

<pre>
CREATE DOMAIN domain [AS] <datatype>
[DEFAULT {literal | NULL | USER}]
[NOT NULL] [CHECK (<dom_search_condition>)]
[COLLATE collation];

<datatype> =
{SMALLINT|INTEGER|FLOAT|DOUBLE PRECISION}[<array_dim>]
| {DATE|TIME|TIMESTAMP}[<array_dim>]
| {DECIMAL | NUMERIC} [(precision [, scale])] [<array_dim>]
| {CHAR | CHARACTER | CHARACTER VARYING | VARCHAR} [(int)]
[<array_dim>] [CHARACTER SET charname]
| {NCHAR | NATIONAL CHARACTER | NATIONAL CHAR}
[VARYING] [(int)] [<array_dim>]
| BLOB [SUB_TYPE {int | subtype_name}] [SEGMENT SIZE int]
[CHARACTER SET charname]
| BLOB [(seglen [, subtype])]

<array_dim> = [[x:]y [, [x:]y …]]

<dom_search_condition> =
VALUE <operator> value
| VALUE [NOT] BETWEEN value AND value
| VALUE [NOT] LIKE value [ESCAPE value]
| VALUE [NOT] IN (value [, value …])
| VALUE IS [NOT] NULL
| VALUE [NOT] CONTAINING value
| VALUE [NOT] STARTING [WITH] value
| (<dom_search_condition>)
| NOT <dom_search_condition>
| <dom_search_condition> OR <dom_search_condition>
| <dom_search_condition> AND <dom_search_condition>

<operator> = {= | < | > | <= | >= | !< | !> | <> | !=}
</pre>

← Предыдущая		Версия 11:01, 18 июня 2014
Строка 1:		Строка 1:
	[http://firebirdsql.su/doku.php?id=create_domain CREATE DOMAIN]		[http://firebirdsql.su/doku.php?id=create_domain CREATE DOMAIN]

−	[[Category:~~База данных~~]]	+	[[Category:Firebird]]

@@ Строка 1: / Строка 1: @@
+<source lang="sql">
-<pre>
 CREATE DOMAIN domain [AS] <datatype>
    [DEFAULT {literal | NULL | USER}]
@@ Строка 34: / Строка 33: @@
 <operator> = {= | < | > | <= | >= | !< | !> | <> | !=}
-</pre>
+</source>

@@ Строка 1: / Строка 1: @@
-<source lang="sql">
+[http://firebirdsql.su/doku.php?id=create_domain CREATE DOMAIN]
-CREATE DOMAIN domain [AS] <datatype>
-  [DEFAULT {literal | NULL | USER}]
-  [NOT NULL] [CHECK (<dom_search_condition>)]
-  [COLLATE collation];
-<datatype> =
+[[Category:База данных]]
-{SMALLINT|INTEGER|FLOAT|DOUBLE PRECISION}[<array_dim>]
-| {DATE|TIME|TIMESTAMP}[<array_dim>]
-| {DECIMAL | NUMERIC} [(precision [, scale])] [<array_dim>]
-| {CHAR | CHARACTER | CHARACTER VARYING | VARCHAR} [(int)]
-[<array_dim>] [CHARACTER SET charname]
-| {NCHAR | NATIONAL CHARACTER | NATIONAL CHAR}
-[VARYING] [(int)] [<array_dim>]
-| BLOB [SUB_TYPE {int | subtype_name}] [SEGMENT SIZE int]
-[CHARACTER SET charname]
-| BLOB [(seglen [, subtype])]
-−
-<array_dim> = [[x:]y [, [x:]y …]]
-−
-<dom_search_condition> =
-VALUE <operator> value
-| VALUE [NOT] BETWEEN value AND value
-| VALUE [NOT] LIKE value [ESCAPE value]
-| VALUE [NOT] IN (value [, value …])
-| VALUE IS [NOT] NULL
-| VALUE [NOT] CONTAINING value
-| VALUE [NOT] STARTING [WITH] value
-| (<dom_search_condition>)
-| NOT <dom_search_condition>
-| <dom_search_condition> OR <dom_search_condition>
-| <dom_search_condition> AND <dom_search_condition>
-−
-<operator> = {= | < | > | <= | >= | !< | !> | <> | !=}
-</source>
-−
-[[Category:SQL]]