Query SQL for CV Domains assigned to Feature Classes

ThomasKonzel — Fri, 21 May 2021 16:17:22 GMT

In cleaning up our long list of cv domains in our 5 geodatabases, we wanted a quick way to list the domains and what feature class(es) they were assigned to. I searched online but didn't find anything, so we came up with this little query to list our feature classes with associated domains. No question - just sharing. Hope this can help someone in the future.

SELECT I.Name as "CV Domain Name", I.Type, RI.Name as "Feature Class Name"
FROM [GDBName].[sde].[GDB_ITEMS] as I
Left Outer Join
(SELECT I.Name, OriginID, DestID
FROM [GDBName].[sde].[GDB_ITEMRELATIONSHIPS] as R
Inner Join [GDBName].[sde].[GDB_ITEMS] as I
On r.OriginID = I.UUID) as RI
On I.UUID = RI.DestID
where i.Type = '8C368B12-A12E-4C7E-9638-C9C64E69E98F' --This Type is Coded Value Domain
Order by I.Name, RI.Name

topic Query SQL for CV Domains assigned to Feature Classes in Geodatabase Questions

Query SQL for CV Domains assigned to Feature Classes