Delete / Drop .gpkg table / layer

[nick4rivers]

Hey @philipbaileynar, @KellyMWhitehead, and @MattReimer

Looking for suggestions on deleting table/layer on disk from a .gpkg from within the plugin? Seems like this may be outside of the pyqgis libraries.

Is this a time I might just move to SQL to DROP the table/layer? I've experimented using the Qt.Sql library which might be the way to go. any insight for your experience on this would be helpful?

[nick4rivers]

Actually - seems like this simple gdal will work:

gpkg = gdal.OpenEx('/Users/nick/Desktop/My_Test/ProjectLayers.gpkg', gdal.OF_UPDATE, allowed_drivers=['GPKG'])
error = gpkg.DeleteLayer('active_floodplains')
gpkg.ExecuteSQL('VACUUM')