Use database view as domain

[Bud]

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

[Bud]

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.