English

FAQ: Can database views be registered with the geodatabase?

Question

Can database views be registered with the geodatabase?

Answer

Under certain scenarios, database views can be registered with the geodatabase. This can vary depending on the ArcGIS client release and how the view was created. For example:

  • A database view created using the SDE command line tools (eg: sdetable -o create_view) can be registered with the geodatabase in ArcGIS 10.2.
  • A database view created using the Create Database View tool in ArcGIS 10.2 cannot be registered with the geodatabase.

Registering database views with the geodatabase is not an intended workflow. Please see the Registering a table with the geodatabase help topic that explains why this should not be permitted: 

"Because ArcGIS cannot add an ObjectID field to a view or update the values in an existing ObjectID field in a view, you cannot register a view with the geodatabase."

Going forward, ArcGIS 10.3 and 10.2.1 UTUP 3 includes a change that no longer permits registering database views created via the command line tools with the geodatabase.