ALTER TABLE - История изменений

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

2014-06-18T11:01:41Z

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

2014-06-18T10:59:22Z

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

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

2009-10-07T07:58:21Z

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

2007-03-02T10:15:36Z

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

<pre>
ALTER TABLE table <operation> [, <operation> …];

<operation> = ADD <col_def>
| ADD <tconstraint>
| ALTER [COLUMN] column_name <alt_col_clause>
| DROP col
| DROP CONSTRAINT constraint

<alt_col_clause> = TO new_col_name
| TYPE new_col_datatype
| POSITION new_col_position

<col_def> = col {<datatype> | COMPUTED [BY] (<expr>) | domain}
[DEFAULT {literal | NULL | USER}]
[NOT NULL]

[<col_constraint>]
[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 …]]

<expr> = A valid SQL expression that results in a single value.

<col_constraint> = [CONSTRAINT constraint]
{ UNIQUE
| PRIMARY KEY
| REFERENCES other_table [(other_col [, other_col …])]
[ON DELETE {NO ACTION|CASCADE|SET DEFAULT|SET NULL}]
[ON UPDATE {NO ACTION|CASCADE|SET DEFAULT|SET NULL}]
| CHECK (<search_condition>)}

<tconstraint> = [CONSTRAINT constraint]
{{PRIMARY KEY | UNIQUE} (col [, col …])
| FOREIGN KEY (col [, col …])
REFERENCES other_table [(other_col [, other_col …])]
[ON DELETE {NO ACTION|CASCADE|SET DEFAULT|SET NULL}]
[ON UPDATE {NO ACTION|CASCADE|SET DEFAULT|SET NULL}]
| CHECK (<search_condition>)}

<search_condition> = <val> <operator> {<val> | (<select_one>)}
| <val> [NOT] BETWEEN <val> AND <val>
| <val> [NOT] LIKE <val> [ESCAPE <val>]
| <val> [NOT] IN (<val> [, <val> …] | <select_list>)
| <val> IS [NOT] NULL
| <val> {>= | <=}
| <val> [NOT] {= | < | >}
| {ALL | SOME | ANY} (<select_list>)
| EXISTS (<select_expr>)
| SINGULAR (<select_expr>)
| <val> [NOT] CONTAINING <val>
| <val> [NOT] STARTING [WITH] <val>
| (<search_condition>)
| NOT <search_condition>
| <search_condition> OR <search_condition>
| <search_condition> AND <search_condition>

<val> = { col [<array_dim>] | :variable
| <constant> | <expr> | <function>
| udf ([<val> [, <val> …]])
| NULL | USER | RDB$DB_KEY | ? }
[COLLATE collation]

<constant> = num | 'string' | charsetname 'string'

<function> = COUNT (* | [ALL] <val> | DISTINCT <val>)
| SUM ([ALL] <val> | DISTINCT <val>)
| AVG ([ALL] <val> | DISTINCT <val>)
| MAX ([ALL] <val> | DISTINCT <val>)
| MIN ([ALL] <val> | DISTINCT <val>)
| CAST (<val> AS <datatype>)
| UPPER (<val>)
| GEN_ID (generator, <val>)

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

<select_one> = SELECT on a single column; returns exactly one value.

<select_list> = SELECT on a single column; returns zero or more values.

<select_expr> = SELECT on a list of values; returns zero or more
values.
</pre>

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

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

@@ Строка 1: / Строка 1: @@
-<pre>
+[http://firebirdsql.su/doku.php?id=alter_table ALTER TABLE]
-ALTER TABLE table <operation> [, <operation> …];
-<operation> = ADD <col_def>
+[[Category:База данных]]
-| ADD <tconstraint>
-| ALTER [COLUMN] column_name <alt_col_clause>
-| DROP col
-| DROP CONSTRAINT constraint
-−
-<alt_col_clause> = TO new_col_name
-| TYPE new_col_datatype
-| POSITION new_col_position
-−
-<col_def> = col {<datatype> | COMPUTED [BY] (<expr>) | domain}
-[DEFAULT {literal | NULL | USER}]
-[NOT NULL]
-−
-[<col_constraint>]
-[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 …]]
-−
-<expr> = A valid SQL expression that results in a single value.
-−
-<col_constraint> = [CONSTRAINT constraint]
-{ UNIQUE
-| PRIMARY KEY
-| REFERENCES other_table [(other_col [, other_col …])]
-[ON DELETE {NO ACTION|CASCADE|SET DEFAULT|SET NULL}]
-[ON UPDATE {NO ACTION|CASCADE|SET DEFAULT|SET NULL}]
-| CHECK (<search_condition>)}
-−
-<tconstraint> = [CONSTRAINT constraint]
-{{PRIMARY KEY | UNIQUE} (col [, col …])
-| FOREIGN KEY (col [, col …])
-REFERENCES other_table [(other_col [, other_col …])]
-[ON DELETE {NO ACTION|CASCADE|SET DEFAULT|SET NULL}]
-[ON UPDATE {NO ACTION|CASCADE|SET DEFAULT|SET NULL}]
-| CHECK (<search_condition>)}
-−
-<search_condition> = <val> <operator> {<val> | (<select_one>)}
-| <val> [NOT] BETWEEN <val> AND <val>
-| <val> [NOT] LIKE <val> [ESCAPE <val>]
-| <val> [NOT] IN (<val> [, <val> …] | <select_list>)
-| <val> IS [NOT] NULL
-| <val> {>= | <=}
-| <val> [NOT] {= | < | >}
-| {ALL | SOME | ANY} (<select_list>)
-| EXISTS (<select_expr>)
-| SINGULAR (<select_expr>)
-| <val> [NOT] CONTAINING <val>
-| <val> [NOT] STARTING [WITH] <val>
-| (<search_condition>)
-| NOT <search_condition>
-| <search_condition> OR <search_condition>
-| <search_condition> AND <search_condition>
-−
-<val> = { col [<array_dim>] | :variable
-| <constant> | <expr> | <function>
-| udf ([<val> [, <val> …]])
-| NULL | USER | RDB$DB_KEY | ? }
-[COLLATE collation]
-−
-<constant> = num | 'string' | charsetname 'string'
-−
-<function> = COUNT (* | [ALL] <val> | DISTINCT <val>)
-| SUM ([ALL] <val> | DISTINCT <val>)
-| AVG ([ALL] <val> | DISTINCT <val>)
-| MAX ([ALL] <val> | DISTINCT <val>)
-| MIN ([ALL] <val> | DISTINCT <val>)
-| CAST (<val> AS <datatype>)
-| UPPER (<val>)
-| GEN_ID (generator, <val>)
-−
-<operator> = {= | < | > | <= | >= | !< | !> | <> | !=}
-−
-<select_one> = SELECT on a single column; returns exactly one value.
-−
-<select_list> = SELECT on a single column; returns zero or more values.
-−
-<select_expr> = SELECT on a list of values; returns zero or more values.
-</pre>
-−
-[[Category:SQL]]