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 928 times
0
Human Cyborg Relations
- 1,132
- 4
- 25
- 48
-
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