Frequently asked question

Are Computed/Virtual columns supported in an Enterprise environment in ArcGIS?

Last Published: April 25, 2020

Answer

No, Computed Columns (SQL Server) and Virtual Columns (Oracle and PostgreSQL) are not supported in ArcGIS geodatabases.

A computed/virtual column is populated dynamically and is not physically stored with the table. Computed/virtual columns are read-only. The geodatabase does not support auto-populated fields such as computed columns or automatically incrementing fields.

Database tables utilizing these columns can be viewed in ArcGIS using Query Layers or Database Views, but the tables or feature classes cannot be registered with the geodatabase. If a computed/virtual column is added to a table that is already registered with the geodatabase, the table cannot be enabled for archiving or registered as versioned for editing.

Article ID: 000008488

Software:
  • ArcMap
  • ArcGIS Pro 1 x

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