Hi Andrzej,
Thanks for the advice, I really thought I was on to a winner, BUT, in my 10.0 SDE schema I do not have a gdb_featureclasses or a gdb_objectclasses table. Are you using an earlier version perhaps?
I have looked for columns with ALIAS in their name, but only have SDE.SDE_XML_INDEX_TAGS.TAG_ALIAS.
SDE.GDB* tables I have are GDB_ITEMS, GDB_ITEMRELATIONSHIPTYPES, GDB_ITEMRELATIONSHIPS, GDB_ITEMTYPES, GDB_REPLICALOG, GDB_TABLES_LAST_MODIFIED.
thanks
Mike