This topic describes how to change the default schema to another in DRDS by executing the USE command.
Background information
Precautions
- You must authorize the database in advance. For more information, see account and permission system.
- After the default database is changed, the HINT syntax and SEQUENCE syntax in the original SQL statement are also directed to the new database by default, no matter whether a schema is specified.
Syntax
USE db_name
Examples
You can use the following syntax to switch the current default database to NEW_DB
.
USE NEW_DB