Thanks, Hiranya, a small addition to my previous comment:
>> For example, for a view, the SYSVIEWS table contains a reference to >> the owning schema in the column COMPILATIONSCHEMAID. The system table >> for schemas, SYSSCHEMAS, contains AUTHORIZATIONID for each >> schema. This is the owning user user (since Derby does not yet support >> a schema being owned by a role, although the SQL standard does allow >> that). So joining COMPILATIONSCHEMAID with SYSSCHEMAS.SCHEMAID gives >> the owning user of a view. The case is similar for triggers and >> constraints. and, of course, and tables and routines (the latter are found in SYSALIASES). Dag
