Background documentationUSE SCHEMA Command Locate this document in the navigation structure


You can use the Loader command USE SCHEMA to specify which schema the current user should use.


Syntax Syntax

  1. <use_schema_command> ::=
      USE SCHEMA <schema_name>
End of the code.

If the name of the schema is identical to a keyword or if upper and lowercase notation is relevant, the name must be placed in double quotation marks.

This setting applies if no other schema is specified with a USE SCHEMA, USE USER or SET CURRENT SCHEMA command.


Example Example


End of the example.

The current database user should use the HOTEL schema.