Documentation Source Text

Check-in [f12d719b3c]
Login

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

Overview
Comment:Fixed #3019.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: f12d719b3c95d49e5b4e99584671beb2e17b41da
User & Date: mihailim 2008-06-25 06:43:40.000
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
Unified Diff Ignore Whitespace Patch
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