topic Creating ESRI_OID in SQL Server in Data Management Questions

Creating ESRI_OID in SQL Server

ScottMoyer — Thu, 14 May 2015 14:59:28 GMT

I have read-only access to a non-spatial SQL server. The table I want to use doesn't have object IDs, needed for queries, while another table shows the ESRI_OID field ("shows" as it really isn't in the table). How do I get the ESRI_OID field to show in the table? Also, I'm unable to Register with Geodatabase. If I were to have a new OID field added to the SQL table, what do I tell the database administrator, create a random number field?

Thanks,

Scott

Re: Creating ESRI_OID in SQL Server

JoshuaBixby — Thu, 14 May 2015 20:08:06 GMT

There are a couple tools, or more, in the Layers and Table Views toolset that should work for you: Make Query Table, Make Query Layer. These tools will create virtual key fields, i.e., ESRI_OID, for you.

Re: Creating ESRI_OID in SQL Server

ScottMoyer — Tue, 19 May 2015 15:46:40 GMT

Thanks for the reply Joshua. I've had only minor success. Make Query Table errored as I believe that I need write access to the table. (I had success on writable tables.) When I employ Make Query Layer in a model, the output isn't recognized, using Get Count for testing. My only success was that I created the ESRI_OID field in ArcMap by Add Query Layer, but then my model, run from ArcMap, still doesn't recognize the query output.

At this point I'm going to have the database administrator add an OID field.

Scott