Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Revisions to the arbitrary table schema change text in ALTER TABLE. |
|---|---|
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
b730943d19f0cff41ef4ecdcad293828 |
| User & Date: | drh 2014-05-25 22:00:25 |
Context
|
2014-05-25
| ||
| 22:11 | Make sure fileformat.html stays in sync with fileformat2.html. check-in: df6145bd4e user: drh tags: trunk | |
| 22:00 | Revisions to the arbitrary table schema change text in ALTER TABLE. check-in: b730943d19 user: drh tags: trunk | |
| 21:54 | Add instructions for how to do arbitrary schema changes to the ALTER TABLE documentation. check-in: 227fb14d50 user: drh tags: trunk | |
Changes
Changes to pages/lang.in.
208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 |
Run an [INSERT | INSERT INTO X SELECT ... FROM old_X] command to transfer content from the old version of X into the new X. <li><p> Drop the old X table using [DROP TABLE | DROP TABLE old_X]. <li><p> Recreate all the indexes, triggers, and views that were dropped in step 1 above and that remain relevant after the table alteration using approprate [CREATE INDEX], [CREATE TRIGGER], and [CREATE VIEW] commands. </ol> <p>If some future version of SQLite adds new ALTER TABLE capabilities, it will probably do so using the steps outlined above. <tcl> # One of the reasons that # SQLite does not currently support more ALTER TABLE capabilities is that |
> | < | | > > > > |
208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 |
Run an [INSERT | INSERT INTO X SELECT ... FROM old_X] command to transfer content from the old version of X into the new X. <li><p> Drop the old X table using [DROP TABLE | DROP TABLE old_X]. <li><p> Issue [CREATE INDEX], [CREATE TRIGGER], and [CREATE VIEW] to recreate the indexes, triggers, and views that were dropped in step 1 above with changes appropriate for the altered table definition. </ol> <p>If desired, all of the steps above can be carried out inside of a [BEGIN | transaction] so that the schema change is atomic. <p>If some future version of SQLite adds new ALTER TABLE capabilities, it will probably do so using the steps outlined above. <tcl> # One of the reasons that # SQLite does not currently support more ALTER TABLE capabilities is that |