score:1

Accepted answer

the ones with names starting "sys" are often called the "system catalogs", or "system tables", and they are automatically created by and managed by derby itself.

you can read about them in the derby reference manual: http://db.apache.org/derby/docs/10.11/ref/

for example, see: derby system tables (http://db.apache.org/derby/docs/10.11/ref/rrefsistabs38369.html) and syscs diagnostic tables (http://db.apache.org/derby/docs/10.11/ref/rrefsyscsdiagtables.html).

the "app" schema, on the other hand, is a normal user schema. user schemas are created for each user when they connect to the database and create a database object like a table or view. the "app" user is the default username if you do not provide a username of your own, so that is why you are seeing it there.

i'm not sure why you are seeing a "sqlj" schema. did you look inside it to see what tables it contains?


Related Query

More Query from same tag