topic how to get all the coded value from a domain in an SDE to a table in Geodatabase Questions

how to get all the coded value from a domain in an SDE to a table

lelaharrington — Tue, 26 Apr 2016 17:38:54 GMT

trying to get all the values of a domain so i can check it for updates that are needed. i would like to get it in tabular form and then bacble to modify and republish it to the domain when completed.

Re: how to get all the coded value from a domain in an SDE to a table

WesMiller — Tue, 26 Apr 2016 17:44:49 GMT

Have a look at Domain To Table—Help | ArcGIS for Desktop

Re: how to get all the coded value from a domain in an SDE to a table

ThomasColson — Sun, 12 Dec 2021 09:40:46 GMT

This will create a view (sort of table) that will display your coded value domain:

CREATE VIEW [dbo].[View_Landform]
AS
SELECT    codedValue.value('Code[1]', 'nvarchar(max)') AS , codedValue.value('Name[1]', 'nvarchar(max)') AS [Value]
FROM        dbo.GDB_ITEMS AS items INNER JOIN
                      dbo.GDB_ITEMTYPES AS itemtypes ON items.Type = itemtypes.UUID CROSS APPLY items.Definition.nodes('/GPCodedValueDomain2/CodedValues/CodedValue')
                      AS CodedValues(codedValue)
WHERE    itemtypes.Name = 'Coded Value Domain' AND items.Name = 'Landform'
GO

The edit method described in Re-order Attribute Domain Values can also be used to execute the edits you desire without having to remove the domain from the FC attribute and re-import it.

Re: how to get all the coded value from a domain in an SDE to a table

JenniferMcCall4 — Wed, 11 May 2016 11:35:32 GMT

You can also check out XRay http://www.arcgis.com/home/item.html?id=e1e911d7d7374285b1ef03d06b3ee642 .

I believe you can use this to push domain edits back into the GDB.