English

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

Question

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

Answer

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

A computed/virtual column does not get stored in physical storage and is read-only. The geodatabase does not support auto-populated fields such as computed columns or auto-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 as versioned for editing.