Feature request #4956

Delete columns in SQLite tables

Added by Giuseppe Sucameli about 8 years ago. Updated almost 3 years ago.

Status:Open
Priority:Low
Assignee:-
Category:DB Manager
Pull Request or Patch supplied:No Resolution:
Easy fix?:No Copied to github as #:14751

Description

SQLite doesn't support to delete column.
Here's the steps to do this:
1. create another table following the original table's schema,
2. delete the original table
3. rename the new table to the name of original table

History

#1 Updated by Giovanni Manghi about 7 years ago

  • Project changed from 27 to QGIS Application

#2 Updated by Giovanni Manghi about 7 years ago

  • Category set to DB Manager

#3 Updated by Giovanni Manghi about 7 years ago

  • Assignee deleted (Giuseppe Sucameli)

#4 Updated by Giovanni Manghi almost 3 years ago

  • Easy fix? set to No

Also available in: Atom PDF