Hello,where are the fields'aliasnames of featureclasses stored in ArcSDE10 GeoDatabas

Question

In ArcSDE9.3 Geodatabase,there is a table called "GDB_FIELDINFO" storing fields'aliasnames for all featureclass tables.But in ArcSde10,that table does no longer exist.I have almost searched all the tables in ArcSDE10 geodatabase for those aliasnames,but only to find nothing. Can someone tell me where are aliasnames stored,please?

jincheng · Answer

The information remains in the database; they're just stored as CLOB text strings in the
few remaining sde.GDB_* tables.  The denormalized form makes opening a geodatabase 
significantly faster, but by being more computer-ready, they're less human-readable
(and *much* less human-writable).

It's been a while since 10.0 was released, but these changes were discussed at great length
when they happened, and the documentation has been updated to reflect the new architecture.
I encourage you to delve into the "What's New at 10.0" documents to familiarize yourself with
the other changes.

- V

Got it. Thank you.

VinceAngelo · Answer

The information remains in the database; they're just stored as CLOB text strings in the
few remaining sde.GDB_* tables.  The denormalized form makes opening a geodatabase 
significantly faster, but by being more computer-ready, they're less human-readable
(and *much* less human-writable).

It's been a while since 10.0 was released, but these changes were discussed at great length
when they happened, and the documentation has been updated to reflect the new architecture.
I encourage you to delve into the "What's New at 10.0" documents to familiarize yourself with
the other changes.

- V

jincheng · Answer

Everything is stored as XML at ArcGIS 10.  Teasing it out with SQL wouldn't be easy.

- V

So could you please tell me where is XML file in PC system(Win7),ArcSDE10's home direcroy or Geodatabase's home direcroy or anywhere else? I cant't find it.