idea Enable delete field tool to delete fields in a geopackage in Data Management Ideas

Enable delete field tool to delete fields in a geopackage

DuncanHornby — Wed, 17 Jan 2024 18:16:16 GMT

When you use the Delete field tool on a featureclass in a geopackage it throws a 002557 error.

My idea is simply to enable the delete field tool to interact with a geopackage table and allow you to delete the field.

Improving ArcPro's ability to interact with such data formats will encourage the uptake and hopefully the replacement of a shapefile.

Re: Enable delete field tool to delete fields in a geopackage

SeaRM — Mon, 04 Mar 2024 12:28:03 GMT

Didn't you try XTools Pro Delete Multiple Fields online tool? It's free.

https://online.xtools.pro/portal/tools/DeleteMultipleFields

Re: Enable delete field tool to delete fields in a geopackage

TaiDuong — Fri, 04 Apr 2025 19:19:53 GMT

Do this immediately. ArcGIS' inability to interact well with geopackages is pushing us to QGIS

Re: Enable delete field tool to delete fields in a geopackage

DLowery — Wed, 28 May 2025 20:08:31 GMT

@DuncanHornby, thanks for bringing this to our attention. You are receiving the 002557 error because you are using the layer from your map, which is a query layer and is read-only as your input table for the Delete Field tool. If you browse to the location of the Geopackage feature class, you will be able to delete fields from the feature class because this allows schema operations on the underlying table. Hope this helps.

Re: Enable delete field tool to delete fields in a geopackage

DuncanHornby — Thu, 29 May 2025 09:17:30 GMT

@DLowery thanks for clarifying the source of the error and your workaround is easy to implement.

But...

For a consistent user experience I think the tool needs to be able to deal with a layer from a map and I presume (not tested it) a layer object being passed around within a model is also susceptible to this error?

If what I'm suggesting is impossible then at least update the help file for the Delete tool to say the tool has compatible issues with a layer and thus only able to interact with its feature class.