Bug report #2423
spatialite: deleting columns is not allowed
|Affected QGIS version:||Regression?:||No|
|Operating System:||All||Easy fix?:||No|
|Pull Request or Patch supplied:||Resolution:||invalid|
|Crashes QGIS or corrupts data:||Copied to github as #:||12483|
Is the spatialite provider supposed to allow deleting columns in the table of attributes? If yes then in QGIS (tested with trunk) this is not possible. If the answer is no, then please forgive me and close the ticket.
#1 Updated by Sandro Furieri over 10 years ago
Sorry, deleting a column isn't allowed at all in SQLite.
You can add columns to any table after initial CREATE: but changing an already defined column is forbidden anyway.
Accordingly to this, renaming (or deleting) a column is not possible in SQLite/SpatiaLite.