Mobile GDB database view definition includes CREATE VIEW MY_VW AS

Bud — Mon, 08 May 2023 15:50:23 GMT

ArcGIS Pro 3.1.1; mobile geodatabase

Catalog —> Properties —> Definition:
This is what a database view SQL definition looks like for various DB/GDB types:

File geodatabase view:

select objectid, case when type = 'NT' then 1 else 0 end as flag from test_table

Oracle 18c database (non-GDB) view:

select objectid, case when type = 'NT' then 1 else 0 end as flag from test_table

Mobile geodatabase view:

CREATE VIEW TEST_TABLE_NT_FLAG_VW AS select objectid, case when type = 'NT' then 1 else 0 end as flag from test_table

Question:

Why does the mobile GDB view contain CREATE VIEW TEST_TABLE_NT_FLAG_VW AS , whereas FGDB and Oracle views do not?

If I look at the mobile GDB view in a SQL client like DBeaver, I don't see CREATE VIEW TEST_TABLE_NT_FLAG_VW AS in the view definition. I only see it in ArcGIS Pro.

Re: Mobile GDB database view definition includes CREATE VIEW MY_VW AS

Bud — Wed, 17 May 2023 13:49:13 GMT

Esri Case #03335240 - Mobile GDB database view definition includes CREATE VIEW MY_VW AS

BUG-000158324: Mobile GDB view definition contains "CREATE VIEW [name of table] AS" , whereas File geodatabase views and enterprise geodatabase views do not.

topic Mobile GDB database view definition includes CREATE VIEW MY_VW AS in ArcGIS Pro Questions

Mobile GDB database view definition includes CREATE VIEW MY_VW AS

Re: Mobile GDB database view definition includes CREATE VIEW MY_VW AS