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

[JoseSanchez]

Hi all

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

Please advise!
Jose

[VinceAngelo]

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

- V

[JoseSanchez]

Which ones in 9.x?

[VinceAngelo]

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

[JoseSanchez]

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