topic Re: Is there a table that stores all the feature class subtypes? in Data Management Questions

Is there a table that stores all the feature class subtypes?

JoseSanchez — Tue, 23 Nov 2010 18:51:56 GMT

Hi all

Is there a table that stores all the feature class subtypes?

Please advise!
Jose

Re: Is there a table that stores all the feature class subtypes?

VinceAngelo — Tue, 23 Nov 2010 19:03:09 GMT

Yes and no. If I recall, there are four tables at ArcSDE 9.x, and at 10.0
they're stored in XML.

- V

Re: Is there a table that stores all the feature class subtypes?

JoseSanchez — Wed, 24 Nov 2010 14:43:40 GMT

Which ones in 9.x?

Re: Is there a table that stores all the feature class subtypes?

VinceAngelo — Wed, 24 Nov 2010 15:25:40 GMT

Most of the tables with GDB_ prefixes (and a couple that aren't) are involved, really. The
geodatabase object model diagram shows the interaction between the ArcSDE tables, but
I can't find a reference to that diagram right now. It's probably somewhere in your Help
subsystem (I found the 10.0 model easily on my laptop, but don't have 9.3 readily available).

- V

Re: Is there a table that stores all the feature class subtypes?

JoseSanchez — Wed, 24 Nov 2010 16:40:11 GMT

This query works on a personal geodatabase:

SELECT GDB_ObjectClasses.ID, GDB_ObjectClasses.Name, GDB_Subtypes.ClassID, GDB_Subtypes.SubtypeCode, GDB_Subtypes.SubtypeName
FROM GDB_ObjectClasses INNER JOIN GDB_Subtypes ON GDB_ObjectClasses.ID = GDB_Subtypes.ClassID;

Syntax in SDe:

SELECT     [Owner].GDB_OBJECTCLASSES.ID, [Owner].GDB_OBJECTCLASSES.OWNER, [Owner].GDB_OBJECTCLASSES.NAME, [Owner].GDB_SUBTYPES.CLASSID,
                      [Owner].GDB_SUBTYPES.SUBTYPECODE, [Owner].GDB_SUBTYPES.SUBTYPENAME
FROM         [Owner].GDB_OBJECTCLASSES INNER JOIN
                      [Owner].GDB_SUBTYPES ON [Owner].GDB_OBJECTCLASSES.ID = [Owner].GDB_SUBTYPES.CLASSID