Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | Fixed #3019. |
---|---|
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 |