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.

Structure

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 Example

USE SCHEMA hotel

End of the example.

The current database user should use the HOTEL schema.