DROP Syntax error in SQLiteManager

ios sqlite sqlitemanager
Taj rajan picture Taj rajan · Jan 9, 2014 · Viewed 8.7k times · Source

I have downloaded sqlite manager app in Firefox browser and open sqlite manager app.

1) Created database named DBSQLTEST.

2) Created table named SQLTEST contain has threes fields are SLNO, NAME and AGE

3) Inserted new records

But i want remove a ‘AGE’ column in sqltest table

i using sql command like below

ALTER TABLE SQLTEST DROP COLUMN AGE

SQLiteManager message says

SQLiteManager: Likely SQL syntax error: ALTER TABLE SQLTEST DROP COLUMN AGE [ near "DROP": syntax error ] Exception Name: NS_ERROR_FAILURE Exception Message: Component returned failure code: 0x80004005 (NS_ERROR_FAILURE) [mozIStorageConnection.createStatement]

What is error that?

Answer

laalto picture laalto · Jan 9, 2014

sqlite does not support DROP COLUMN in ALTER TABLE. You can only rename tables and add columns.

Reference: http://www.sqlite.org/lang_altertable.html

If you need to remove columns, create a new table, copy the data there, drop the old table and rename the table to its intented name.

Related questions

Convert NSData to String?

I am storing a openssl private Key EVP_PKEY as nsdata. For this I am serializing into a byte stream using the code below unsigned char *buf, *p; int len; len = i2d_PrivateKey(pkey, NULL); buf = OPENSSL_malloc(len); …

Read More
Sqlite File Location Core Data

Typically, the sqlite store file for core data apps is located in Library>Application Support>iPhone Simulator>7.1(or whichever version you are using)>Applications>(Whichever folder contains your app)>Documents folder, but I can't …

Read More
Reading and writing images to an SQLite DB for iPhone use

I've set up a SQLite DB that currently reads and writes NSStrings perfectly. I also want to store an image in the database and recall it later. I've read up a bit on using NSData and encoding the image, but …

Read More