[QGIS-trac] Re: [Quantum GIS] #2423: spatialite: deleting columns is not allowed

[Quantum GIS]

#2423: spatialite: deleting columns is not allowed
-----------------------------------------------------+----------------------
        Reporter:  lutra                             |         Owner:  nobody       
            Type:  bug                               |        Status:  new          
        Priority:  major: does not work as expected  |     Milestone:  Version 1.5.0
       Component:  Data Provider                     |       Version:  HEAD         
      Resolution:                                    |      Keywords:               
Platform_version:                                    |      Platform:  All          
        Must_fix:  Yes                               |   Status_info:  0            
-----------------------------------------------------+----------------------
Comment (by esseffe):

 Sorry, deleting a column isn't allowed at all in SQLite.[[BR]]
 You can add columns to any table after initial CREATE: but changing an
 already defined column is forbidden anyway.[[BR]]
 Accordingly to this, renaming (or deleting) a column is not possible in
 SQLite/SpatiaLite.

 Bye Sandro

-- 
Ticket URL: <https://trac.osgeo.org/qgis/ticket/2423#comment:1>
Quantum GIS <http://qgis.org>
Quantum GIS is an Open Source GIS viewer/editor supporting OGR, PostGIS, and GRASS formats