Query to get all the available object types within a selected context in Windchill

1. You won't be able to write a direct SQL query to retrieve all the Object Types unless you write select * and do a union of all tables.

2. I would highly recommend a Java Program as follows, You can pass the Container Name as an argument in the method, You can create a little utility which can output an excel report based on the Container you provide on the command line, Let me know if you need more help with that.

QuerySpec qs = new QuerySpec(WTContained.class);
QueryResult allContained=PersistenceHelper.manager.find((StatementSpec)qs);

while(allContained.hasMoreElements())
{
WTContained obj=(WTContained) allContained.nextElement();

//logger.debug("-Business Object is instance of WTContained -");

WTContainer container = obj.getContainer();
}