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