Sqlite Drop Column - Revision history

⚠️MilenaN: Reverted edits by Reverse22 (talk) to last revision by Robbiebow

2011-12-30T21:35:07Z

Reverted edits by Reverse22 (talk) to last revision by Robbiebow

← Older revision		Revision as of 21:35, 30 December 2011
Line 41:		Line 41:

	[[Category:FAQ]]		[[Category:FAQ]]

	~~==Other==~~
	~~[http://thetvtopc.com/Reverse_Cell_Phone_Lookup_Number reverse phone lookup]~~

	~~[http://www.prlog.org/11289974-phone-number-lookup-verizon-phone-number-reverse-lookup-to-get-information-you-need-quickly.html phone number lookup]~~

⚠️Reverse22 at 20:57, 30 December 2011

2011-12-30T20:57:29Z

← Older revision		Revision as of 20:57, 30 December 2011
Line 41:		Line 41:

	[[Category:FAQ]]		[[Category:FAQ]]

			==Other==
			[http://thetvtopc.com/Reverse_Cell_Phone_Lookup_Number reverse phone lookup]

			[http://www.prlog.org/11289974-phone-number-lookup-verizon-phone-number-reverse-lookup-to-get-information-you-need-quickly.html phone number lookup]

⚠️Robbiebow at 10:31, 13 October 2009

2009-10-13T10:31:38Z

← Older revision		Revision as of 10:31, 13 October 2009
Line 25:		Line 25:
	foo TEXT PRIMARY KEY,		foo TEXT PRIMARY KEY,
	bar TEXT,		bar TEXT,
	baz INTEGER,		baz INTEGER
	);		);

⚠️Robbiebow at 10:30, 13 October 2009

2009-10-13T10:30:57Z

← Older revision		Revision as of 10:30, 13 October 2009
Line 17:		Line 17:

	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". See also the Firefox SQLite Manager add-on [4], which is similar to SqliteBrowser.		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". See also the Firefox SQLite Manager add-on [4], which is similar to SqliteBrowser.

			Alternatively, you could try this approach, which is slightly fewer steps:

			<pre>
			BEGIN TRANSACTION;
			CREATE TABLE t1_new (
			foo TEXT PRIMARY KEY,
			bar TEXT,
			baz INTEGER,
			);

			INSERT INTO t1_new SELECT foo, bar, baz FROM t1;
			DROP TABLE t1;
			ALTER TABLE t1_new RENAME TO t1;
			COMMIT;
			</pre>

	* [1] http://www.sqlite.org/omitted.html		* [1] http://www.sqlite.org/omitted.html

⚠️HamishBowman: firefox sqlite manager

2008-05-25T13:29:11Z

firefox sqlite manager

← Older revision		Revision as of 13:29, 25 May 2008
Line 16:		Line 16:
	</pre>		</pre>

	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".		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". See also the Firefox SQLite Manager add-on [4], which is similar to SqliteBrowser.

	* [1] http://www.sqlite.org/omitted.html		* [1] http://www.sqlite.org/omitted.html
	* [2] http://www.sqlite.org/faq.html#q11		* [2] http://www.sqlite.org/faq.html#q11
	* [3] http://sqlitebrowser.sourceforge.net/		* [3] http://sqlitebrowser.sourceforge.net/
			* [4] https://addons.mozilla.org/en-US/firefox/addon/5817


	[[Category:FAQ]]		[[Category:FAQ]]

⚠️OneChange at 16:14, 1 August 2007

2007-08-01T16:14:57Z

← Older revision		Revision as of 16:14, 1 August 2007
Line 19:		Line 19:

	* [1] http://www.sqlite.org/omitted.html		* [1] http://www.sqlite.org/omitted.html
	* [2] http://www.sqlite.org/faq.html#~~q13~~		* [2] http://www.sqlite.org/faq.html#q11
	* [3] http://sqlitebrowser.sourceforge.net/		* [3] http://sqlitebrowser.sourceforge.net/

	[[Category:FAQ]]		[[Category:FAQ]]

Neteler: new v.db.dropcol

2007-02-05T13:28:57Z

new v.db.dropcol

← Older revision		Revision as of 13:28, 5 February 2007
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>

Neteler at 20:01, 16 June 2006

2006-06-16T20:01:24Z

← Older revision		Revision as of 20:01, 16 June 2006
Line 19:		Line 19:
	* [2] http://www.sqlite.org/faq.html#q13		* [2] http://www.sqlite.org/faq.html#q13
	* [3] http://sqlitebrowser.sourceforge.net/		* [3] http://sqlitebrowser.sourceforge.net/

			[[Category:FAQ]]

⚠️Dassau at 08:50, 19 May 2006

2006-05-19T08:50:42Z

New page

'''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]:

<pre>
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;
</pre>

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".

* [1] http://www.sqlite.org/omitted.html
* [2] http://www.sqlite.org/faq.html#q13
* [3] http://sqlitebrowser.sourceforge.net/