Documentation Source Text

Check-in [b730943d19]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Revisions to the arbitrary table schema change text in ALTER TABLE.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: b730943d19f0cff41ef4ecdcad2938288a043d14
User & Date: drh 2014-05-25 22:00:25.235
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
Unified Diff Ignore Whitespace Patch
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
︙︙