[Qgis-user] Delete attribute in layer properties fields for SpatiaLite file

[Goyo]

2014-02-10 12:43 GMT+01:00  <francois.terreno at safe-mail.net>:
> QGIS 2.01 _ Layer _ Properties _ Fields _ Toggle editing mode _ Delete column
>
> I have loaded a SpatiaLite file with a few points and polygons.
> I added some new attributes.
> The delete column icon is not active and cannot be used.
> What can I do in addition to activate the delete column icon?

SQLite does not support column deletion. You can find an explanation
and a workaround (not tested here) in the FAQ:
http://www.sqlite.org/faq.html#q11

I think the workaround could conflict with integrity constraints so be
careful. Also do not forget the spatialite stuff, like
AddGeometryColumn().

Goyo