Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Fixed #3019. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
f12d719b3c95d49e5b4e99584671beb2 |
| User & Date: | mihailim 2008-06-25 06:43:40 |
Context
|
2008-06-25
| ||
| 07:05 | Fixed #2326. (check-in: aa8f6b1d0f user: mihailim tags: trunk) | |
| 06:43 | Fixed #3019. (check-in: f12d719b3c user: mihailim tags: trunk) | |
| 06:35 | Typo, fixes #3170. (check-in: 67eb1e7a66 user: mihailim tags: trunk) | |
Changes
Changes to pages/faq.in.
278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 |
faq {
How do I add or delete columns from an existing table in SQLite.
} {
<p>SQLite has limited
<a href="lang_altertable.html">ALTER TABLE</a> support that you can
use to add a column to the end of a table or to change the name of
a table.
If you what make more complex changes the structure of a table,
you will have to recreate the
table. You can save existing data to a temporary table, drop the
old table, create the new table, then copy the data back in from
the temporary table.</p>
<p>For example, suppose you have a table named "t1" with columns
names "a", "b", and "c" and that you want to delete column "c" from
|
| |
278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 |
faq {
How do I add or delete columns from an existing table in SQLite.
} {
<p>SQLite has limited
<a href="lang_altertable.html">ALTER TABLE</a> support that you can
use to add a column to the end of a table or to change the name of
a table.
If you want to make more complex changes in the structure of a table,
you will have to recreate the
table. You can save existing data to a temporary table, drop the
old table, create the new table, then copy the data back in from
the temporary table.</p>
<p>For example, suppose you have a table named "t1" with columns
names "a", "b", and "c" and that you want to delete column "c" from
|