I'm using SQLPro for Mac.
I have a table called mc_question which has a column called name
I've run the following query:
ALTER TABLE mc_question
DROP COLUMN name;
But I get the error: near "DROP": syntax error (Line 2)
Asked
Active
Viewed 932 times
0
Human Cyborg Relations
- 1,202
- 5
- 27
- 52
-
3Which database is the query being executed against? The syntax depends on the DB. – Aniket V Aug 29 '17 at 10:31
-
It's apparently an SQLite database. A google search tells me it doesn't support drop column :\ – Human Cyborg Relations Aug 29 '17 at 10:34
-
See https://stackoverflow.com/questions/5938048/delete-column-from-sqlite-table/5987838#5987838 – dnoeth Aug 29 '17 at 10:37