Hello. I want to delete a column because I set a wrong thing when I was creating it, I made it accept integer when I realized it should be text. When I execute the command listed down I get an error. How can I fix that?
ALTER COLUMN list_of_vietnamese_restaurant DROP COLUMN timeofopen;
Result: near “COLUMN”: syntax error
In line 1:
Hi, welcome to the forums.
Is this sqlite or postgres? Do you mean drop a column from a table?
You need to tweak
It’s a sqlite. Yes I mean to drop a column from a table
double check the first link and your syntax for
I fixed it by making a temporary table, importing data there, dropping the wrong table, creating the okay, importing data there and dropping temporary. Thanks for help