At QGIS 2.14 the style files we have saved in our Spatialite database do not show the labels anymore.

Luckily I have the Layer Definition Files saved that still display the labels, but in trying to re-save (overwrite) the style to the Spatialite database (using the same name), I get the following:

enter image description here

While I'm able to save with a new name, how can I remove the old styles so I don't end up with too many old styles?

EDIT: Turns out the style saved for 2.14 doesn't show the labels either, so maybe this is a bigger issue...

1 Answer 1


I found a plugin (!) called Qspatialite

There is a SQL interface to the styles in your Spatialite database, and you can run SQL commands to view, delete, and rename your styles:

enter image description here

enter image description here

Delete an old style:

enter image description here

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.