Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Improvements to the RENAME COLUMN syntax diagram. |
|---|---|
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA3-256: | c951c8c48208bdabb146717446ca7792 |
| User & Date: | drh 2018-09-06 21:37:48 |
Context
|
2018-09-10
| ||
| 14:56 | Update the change log with recent bug fixes. check-in: eba1c4fd81 user: drh tags: trunk | |
|
2018-09-06
| ||
| 21:37 | Improvements to the RENAME COLUMN syntax diagram. check-in: c951c8c482 user: drh tags: trunk | |
| 20:36 | Fix a long-standing typo in the ALTER TABLE documentation. check-in: 9b5947f2ee user: drh tags: trunk | |
Changes
Changes to art/syntax/alter-table-stmt.gif.
cannot compute difference between binary files
Changes to art/syntax/bubble-generator-data.tcl.
47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 |
}
}
alter-table-stmt {
rightstack
{line ALTER TABLE {optx /schema-name .} /table-name}
{tailbranch
{line RENAME TO /new-table-name}
{line RENAME {optx COLUMN} /old-column-name TO /new-column-name}
{line ADD {optx COLUMN} column-def}
}
}
analyze-stmt {
line ANALYZE {or nil /schema-name /table-or-index-name
{line /schema-name . /table-or-index-name}}
}
|
| |
47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 |
}
}
alter-table-stmt {
rightstack
{line ALTER TABLE {optx /schema-name .} /table-name}
{tailbranch
{line RENAME TO /new-table-name}
{line RENAME {optx COLUMN} /column-name TO /new-column-name}
{line ADD {optx COLUMN} column-def}
}
}
analyze-stmt {
line ANALYZE {or nil /schema-name /table-or-index-name
{line /schema-name . /table-or-index-name}}
}
|
Changes to pages/lang.in.
131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 |
^If the table being renamed has triggers or indices, then these remain
attached to the table after it has been renamed.
Beginning with release 3.25.0 ([dateof:3.25.0]), references to the table
within trigger bodies and view definitions are also renamed.
</p>
<p> The RENAME COLUMN TO syntax changes the
<yyterm>old-column-name</yyterm> of table <yyterm>table-name</yyterm>
into <yyterm>new-column-name</yyterm>. The column name is changed both
within the table definition itself and also within all indexes, triggers,
and views that reference the column. If the column name change would
result in a semantic ambiguity in a trigger or view, then the RENAME
COLUMN fails with an error and no changes are applied.
<p> ^The ADD COLUMN syntax
|
| |
131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 |
^If the table being renamed has triggers or indices, then these remain attached to the table after it has been renamed. Beginning with release 3.25.0 ([dateof:3.25.0]), references to the table within trigger bodies and view definitions are also renamed. </p> <p> The RENAME COLUMN TO syntax changes the <yyterm>column-name</yyterm> of table <yyterm>table-name</yyterm> into <yyterm>new-column-name</yyterm>. The column name is changed both within the table definition itself and also within all indexes, triggers, and views that reference the column. If the column name change would result in a semantic ambiguity in a trigger or view, then the RENAME COLUMN fails with an error and no changes are applied. <p> ^The ADD COLUMN syntax |