Deleting entry of GeoPackage

Question

I created a GeoPackagein QGIS 3.18 that contains different entries (layers).

How can I delete just on entry of this GeoPackage?

Babel · Accepted Answer · 2021-05-03 15:29:01Z

12

In the browser panel, browse to the Geopackage and expand it. Right click the layer you want to delete and select Delete layer.

answered May 3, 2021 at 15:29

Babel

63.1k10 gold badges67 silver badges185 bronze badges

Actually even better than using DB Manager. The Browser-Way offers a little more options like removing single fields or exporting the file as a new one.
– MrXsquared
May 3, 2021 at 15:34
Didn't think about the DB manger , so learned something too :-)
– Babel
May 3, 2021 at 15:56
Amazing!! Thanks for your help
– Markus
May 4, 2021 at 8:41
@Markus, accept the answer with the checkbox
– BERA
Nov 9, 2021 at 8:24
1

Any idea about how to delete a raster layer from a Geopackage? The browser panel or DB Manager aren't working.
– Leo
Jan 18, 2022 at 23:37

Add a comment |

MrXsquared · Accepted Answer · 2021-05-03 15:28:57Z

5

Open Database -> DB Manager

Then create a connection to your desired Geopackage file by right clicking on Geopackage -> New Connection

Now you can see the layers. Right click the one you want to delete, and press delete.

answered May 3, 2021 at 15:28

MrXsquared

32.6k20 gold badges62 silver badges113 bronze badges

But don't be surprised if it doesn't work. It seems to be easier to add them than remove them in 3.18 on Mac.
– wingnut
May 3, 2021 at 15:30
@wingnut no issues here on 3.18 windows version.
– MrXsquared
May 3, 2021 at 15:32
I tried about ten times, but layers refused to delete. Restarting didn't help. I eventually tried to do it with SQLITE, but it corrupted the GPKG. Fortunately, I had a backup. Otherwise, GPKG is nice to store the project and its layers in a single file. I would again only do it at the end of the project so I don't have to delete anything.
– wingnut
May 3, 2021 at 15:41
1

hm, cant test on a mac.. only reason I can think of that the file/layer might be in use at that time? Anyway, consider making a report at QGIS issues site if that persists.
– MrXsquared
May 3, 2021 at 16:06
I created the GPKG on Windows and moved it to the Mac. It read it OK, just couldn't delete any layers. Deleting the lock file didn't help either. Next time I try, I'll submit something if necessary.
– wingnut
May 3, 2021 at 19:10

Add a comment |

2 Answers 2