Select to view content in your preferred language

Mobile GDB database view definition includes CREATE VIEW MY_VW AS

529
1
Jump to solution
05-08-2023 07:41 AM
Bud
by
Esteemed Contributor

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:

Bud_0-1683556247332.png

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

 

Oracle 18c database (non-GDB) view: 

Bud_1-1683556304766.png

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

 

Mobile geodatabase view:

Bud_2-1683556366080.png

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. 

Bud_4-1683556768563.png

 

1 Solution

Accepted Solutions
Bud
by
Esteemed Contributor

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.

View solution in original post

0 Kudos
1 Reply
Bud
by
Esteemed Contributor

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.

0 Kudos