Check for duplicate IDs when creating query layer or registering view with GDB

Bud — Tue, 11 Jul 2023 19:03:24 GMT

When creating a query layer or registering a database view with the geodatabase:

Could functionality be added that would let us easily check the underlying data for duplicate IDs in the unique ID column? It would be part of the create query layer tool or register view tool. Not a separate tool.

I know we ought to check for duplicate IDs when we write the SQL query in a SQL client. But that doesn't always happen.

To prove the point, this related post about duplicate ID errors is very popular (15,000+ hits): https://community.esri.com/t5/arcgis-pro-questions/error-opening-table-in-pro-quot-failed-to-retrieve/m-p/385143/

idea Check for duplicate IDs when creating query layer or registering view with GDB in ArcGIS Pro Ideas

Check for duplicate IDs when creating query layer or registering view with GDB

Re: Check for duplicate IDs when creating query layer or registering view with GDB