Hi Mody,You can get the kind of detailed information you're looking for from the Definition column of the feature class rows in the GDB_Items table. The exact way to do this depends on your DBMS, due to differences in how XML columns are stored across different flavors of SDE, as well as the differences in XML functions across DBMSs. Another consideration is that domains can be associated with a class or with one or more specific subtypes of a class; two different XPaths are required for these two cases.Here's an example of how to do this with SQL Server:DECLARE @DOMAIN_NAME NVARCHAR(MAX);
SET @DOMAIN_NAME = 'Material';
DECLARE @CLASS_DEFS TABLE
(
Name nvarchar(max),
Definition XML
)
INSERT INTO @CLASS_DEFS
SELECT
GDB_ITEMS.Name,
GDB_ITEMS.Definition
FROM
-- Get the domain item's UUID.
((SELECT GDB_ITEMS.UUID AS UUID
FROM GDB_ITEMS INNER JOIN GDB_ITEMTYPES
ON GDB_ITEMS.Type = GDB_ITEMTYPES.UUID
WHERE
GDB_ITEMS.Name = @DOMAIN_NAME AND
GDB_ITEMTYPES.Name IN ('Coded Value Domain', 'Range Domain')) AS Domain
-- Find the relationships with the domain as the DestinationID.
INNER JOIN GDB_ITEMRELATIONSHIPS
ON Domain.UUID = GDB_ITEMRELATIONSHIPS.DestID)
-- Find the names of the origin items in the relationships.
INNER JOIN GDB_ITEMS
ON GDB_ITEMRELATIONSHIPS.OriginID = GDB_ITEMS.UUID;
-- Extract the field definitions.
SELECT
ClassDefs.Name AS "Class Name",
fieldDef.value('Name[1]', 'nvarchar(max)') AS "Field Name",
NULL AS "Subtype Name"
FROM
@CLASS_DEFS AS ClassDefs
CROSS APPLY
Definition.nodes('/*/GPFieldInfoExs/GPFieldInfoEx') AS FieldDefs(fieldDef)
WHERE
fieldDef.value('DomainName[1]', 'nvarchar(max)') = @DOMAIN_NAME
UNION
SELECT
ClassDefs.Name AS "Class Name",
fieldDef.value('FieldName[1]', 'nvarchar(max)') AS "Field Name",
fieldDef.value('(../../SubtypeName)[1]', 'nvarchar(max)') AS "Subtype Name"
FROM
@CLASS_DEFS AS ClassDefs
CROSS APPLY
Definition.nodes('/*/Subtypes/Subtype/FieldInfos/SubtypeFieldInfo') AS FieldDefs(fieldDef)
WHERE
fieldDef.value('DomainName[1]', 'nvarchar(max)') = @DOMAIN_NAME
The Geodatabase blog has a handful of articles that have more information about working with the Definition column in 10.0 Geodatabases, here's an example of one:http://blogs.esri.com/Dev/blogs/geodatabase/archive/2010/03/19/The-Simplified-Geodatabase-Schema-Par...Cheers,James