AnsweredAssumed Answered

SDE Views in ArcGIS 10.4 and OBJECTID field

Question asked by jsn on Nov 7, 2017
Latest reply on Feb 23, 2018 by TMorgan-esristaff

Hello everyone,


When creating an SDE View in ArcSDE 10.4 between a FC and a table. How is the field OBJECTID used?

  1. ignore it and create the SDE view without it. This solution does not work well
  2. add the OBJECTID from the FC
  3. add the OBJECTID from the table

The OBJECTID field in a SDE View is a long integer not an OBJECT ID type. So when I copy the SDE view to another Geodatabase it adds a new field OBJECTID_1 in the new feature class, this one has data type Object ID.



  • ArcSDE 10.2 Oracle
  • ArcSDE 10.4 SQL



Until ArcGIS 10.2 we created SDE Spatial views with the command line, and they worked fine:

sdetable -o create_view -T ProjectInfo -t "Project, Project_Table" 
-c "Project.SHAPE, Project.OBJECTID, Project.ProjectID, Project_Table.DATEOFFERED, Project_Table.DATEEXECUTED, Project_Table.Project_STATUS,Project_Table.PROJECTNAME" 
-a "SHAPE, OBJECTID, ProjectID, DateOFFERED, DateEXECUTED,STATUS, PROJECTNAME"  -w "Project.ProjectID IS NOT NULL AND  Project.ProjectID = Project_Table.ProjectID"   



Now in ArcGIS 10.4 we are creating SDE Spatial Views directly in ArcCatalog and the OBJECTID field has some issues


CREATE VIEW ProjectInfo  AS  SELECT  Project_Table.OBJECTID, Project.SHAPE, Project.ProjectID, Project_Table.ProjectSTATUS AS STATUS ,Project_Table.DATEOFFERED, Project_Table.DATEEXECUTED, Project_Table.PROJECTNAME   FROM Project INNER JOIN Project_Table ON  Project.ProjectID = Project_Table.ProjectID WHERE (NOT (Project.ProjectID IS NULL))