Monday 16 June 2014

Derby- Schema Name




There are basically two ways to control the default schema name:
  1. Issue the SET SCHEMA statement after you have connected to the database.
  1. Login as the user with the same name as the schema you wish to use.
If you haven't issued a SET SCHEMA statement, then Derby will use your username as the schema name.
So if you login as user "APP", and don't issue a SET SCHEMA statement, then your schema name will be APP.

No comments:

Post a Comment

Please comment here