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.
Solved! Go to Solution.
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.
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.