SQL table to SQL geodatabase table - Can I set OBJECTID as PK?

AndreaB_ — Tue, 13 May 2025 16:48:07 GMT

Hi all!

I have 4 SQL database tables that I bring into a SQL geodatabase using Esri's Export Table tool in ArcGIS Pro 3.2.4. I have edited the configuration parameters so that when I bring in a nonspatial business table the B_CLUSTER_ROWID config_string is 1 and it will create a clustered index on the OBJECTID field (that was a rabbit hole to even find that it was creating a non-clustered index without this parameter changed). https://pro.arcgis.com/en/pro-app/3.3/help/data/geodatabases/manage-sql-server/alter-configuration-keywords.htm

However, I see that OBJECTID isn't set as the PK. Do I need to go into SSMS and set it as the PK? Is there an Esri tool/setting that will do this? I hope so as I'm trying to put this into Model Builder. Is it not a big deal from the SQL side if there is a PK set or not? (not a DBA here. I'm coming at this from the GISP side).

See similar question with no answer from 2018, Why does ArcGIS create a Primary Key in case of Feature Classes, but a Unique Index in case of Geodatabase Table: https://community.esri.com/t5/data-management-questions/why-there-is-no-primary-key-for-tables/m-p/248544

Thank you for any help! You all are magnificent on here.

topic SQL table to SQL geodatabase table - Can I set OBJECTID as PK? in Geodatabase Questions

SQL table to SQL geodatabase table - Can I set OBJECTID as PK?