topic SQL Spatial in ArcGIS Pro - integer coming in as an objectID in ArcGIS Pro Questions https://community.esri.com/t5/arcgis-pro-questions/sql-spatial-in-arcgis-pro-integer-coming-in-as-an/m-p/1023256#M36879 <P>In bringing a SQL Spatial table layer into ArcGIS Pro, in the translation, a field in the SQL Server Spatial table <STRONG>app607_flag</STRONG> <STRONG>int</STRONG> <STRONG>NOT NULL (from the SQL DDL)</STRONG>, comes in as <STRONG>app607_flag, <U>Object ID</U>, FALSE</STRONG> (no nulls allowed), <STRONG>but hides the field in ArcGIS Pro</STRONG>.&nbsp; We did not see the data in the output and found that this is why.&nbsp; There are two other fields with similar settings come in as expected as Long, FALSE and they are not hidden in the output.</P><P>If anyone can tell us why this is, it would help us figure out whether this is something that the SQL Server DBA can correct, or is it a BUG?</P><P>We were able to unhide this field, but it still shows up as an ObjectID.&nbsp; Any suggestions as to why this might be?</P> Thu, 04 Feb 2021 00:53:14 GMT EllenNodwell_IntegraShare 2021-02-04T00:53:14Z SQL Spatial in ArcGIS Pro - integer coming in as an objectID https://community.esri.com/t5/arcgis-pro-questions/sql-spatial-in-arcgis-pro-integer-coming-in-as-an/m-p/1023256#M36879 <P>In bringing a SQL Spatial table layer into ArcGIS Pro, in the translation, a field in the SQL Server Spatial table <STRONG>app607_flag</STRONG> <STRONG>int</STRONG> <STRONG>NOT NULL (from the SQL DDL)</STRONG>, comes in as <STRONG>app607_flag, <U>Object ID</U>, FALSE</STRONG> (no nulls allowed), <STRONG>but hides the field in ArcGIS Pro</STRONG>.&nbsp; We did not see the data in the output and found that this is why.&nbsp; There are two other fields with similar settings come in as expected as Long, FALSE and they are not hidden in the output.</P><P>If anyone can tell us why this is, it would help us figure out whether this is something that the SQL Server DBA can correct, or is it a BUG?</P><P>We were able to unhide this field, but it still shows up as an ObjectID.&nbsp; Any suggestions as to why this might be?</P> Thu, 04 Feb 2021 00:53:14 GMT https://community.esri.com/t5/arcgis-pro-questions/sql-spatial-in-arcgis-pro-integer-coming-in-as-an/m-p/1023256#M36879 EllenNodwell_IntegraShare 2021-02-04T00:53:14Z