Frequently asked question

Is the Identity data type supported in versioned SQL Server geodatabases?

Last Published: April 25, 2020

Answer

No. ArcSDE doesn't support columns when the Identity property is set to True in SQL Server. Tables or feature classes with this property cannot be edited in ArcMap or registered as versioned. The reason the Identity data type is not supported with versioned data in ArcSDE is because there is no way to coordinate an identity field on the business table and the delta tables (adds and deletes).

The following error is received when attempting to register a feature class containing a column with an Identity data type as versioned.

"Failed to register as versioned Invalid column data type [Database.owner.Feature_class]"

• For additional information on the supported SQL Server data types in ArcGIS, please review the information found at the following link: SQL Server data types supported in ArcGIS

Article ID:000011579

Software:
  • Legacy Products

Receive notifications and find solutions for new or common issues

Get summarized answers and video solutions from our new AI chatbot.

Download the Esri Support App

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options