Use database view as domain

Bud — Thu, 08 Jun 2023 16:31:21 GMT

It would be great if we could use the rows from a database view as a domain, as an optional alternative to storing domain values in the GDB_ITEMS XML table.

For example, a SQL database view that gets the rows from this table, where WMS_DIVISION = ROADS. Use those rows as the domain values.

select distinct
    type as code,
    wms_classification as description
from
    atn_type_translation
where
    wms_division = 'ROADS'

Related: Use SDE table as Domain Table

Re: Use database view as domain

Bud — Mon, 26 Feb 2024 17:01:20 GMT

If performance of the view is ever a concern, then in enterprise geodatabases, we have options available, such as materialized views in Oracle and indexed views in SQL Server.

idea Use database view as domain in ArcGIS Pro Ideas

Use database view as domain

Re: Use database view as domain