The mobile geodatabase view definition contains 'CREATE VIEW [name of table] AS', whereas file geodatabase views and enterprise geodatabase views do not.

Solution de contournement

Database views in all types of databases use CREATE VIEW MY_VW AS to create a database view. That's standard SQL. For example, if a view were to be created in any kind of enterprise geodatabase, the Create Database View geoprocessing tool sends this SQL script to the DB: CREATE VIEW MY_VW AS... However, this is not intentionally displayed in file or enterprise geodatabase views.

Use Case: 

Since CREATE VIEW MY_VW AS is used inconsistently in the view properties of different geodatabase types, it makes it cumbersome to do things like use Python for a variety of different geodatabase types to automatically document view SQL definitions. Since Mobile geodatabases are an exception, check if the geodatabase type is a mobile geodatabase, then strip CREATE VIEW MY_VW AS from the view definition. The same applies to making Entity Relationship diagrams using automated diagramming software.

Étapes pour reproduire