Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Deleting columns in sqlite... causes sql syntax error #9176

Closed
katsar0v opened this issue Jul 6, 2020 · 5 comments
Closed

Deleting columns in sqlite... causes sql syntax error #9176

katsar0v opened this issue Jul 6, 2020 · 5 comments

Comments

@katsar0v
Copy link

katsar0v commented Jul 6, 2020

I just installed dbeaver and created an sqlite database to have a play with it. I created some columns and wanted to delete one, but it fails:

image
image

@uslss
Copy link
Member

uslss commented Jul 6, 2020

Hi @katsar0v ,
SQLite does not support ALTER TABLE DROP COLUMN statement. You could find how to do it here
BR

@katsar0v
Copy link
Author

katsar0v commented Jul 6, 2020

Then why did dbeaver allow me to delete columns, and if possible, why did the wrong syntax was written?

@uslss
Copy link
Member

uslss commented Jul 15, 2020

Feature request to solve this is already created #5447

@uslss uslss closed this as completed Jul 15, 2020
@katsar0v
Copy link
Author

Ok, closed an issue because of "solved" or "won't solve"? This is definitely a bug and unwanted behavior in dbeaver

@uslss
Copy link
Member

uslss commented Jul 17, 2020

@katsar0v issue is closed as a duplicate of already existing feature request. Drop Column behaviour will be implemented in scope of #5447

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

3 participants