Sqlite Drop Column: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
(new v.db.dropcol) |
||
Line 1: | Line 1: | ||
'''Q:''' How can I drop a column in sqlite-databases? | '''Q:''' How can I drop a column in sqlite-databases? | ||
'''A:''' It is not possible to drop columns within sqlite using the syntax ALTER TABLE DROP COLUMN [1]. However, there is a workaround for this issue [2]: | New '''A:''' GRASS 6.3.cvs contains v.db.dropcol which supports it. | ||
Old '''A:''' It is not possible to drop columns within sqlite using the syntax ALTER TABLE DROP COLUMN [1]. However, there is a workaround for this issue [2]: | |||
<pre> | <pre> |
Revision as of 13:28, 5 February 2007
Q: How can I drop a column in sqlite-databases?
New A: GRASS 6.3.cvs contains v.db.dropcol which supports it.
Old A: It is not possible to drop columns within sqlite using the syntax ALTER TABLE DROP COLUMN [1]. However, there is a workaround for this issue [2]:
BEGIN TRANSACTION; CREATE TEMPORARY TABLE t1_backup(a,b); INSERT INTO t1_backup SELECT a,b FROM t1; DROP TABLE t1; CREATE TABLE t1(a,b); INSERT INTO t1 SELECT a,b FROM t1_backup; DROP TABLE t1_backup; COMMIT;
It's obvious that this is a little bit complex. But if you use sqlitebrowser [3] this can be done with a few mouse-clicks (look under -->modify table for a button "remove field".