use-database.mdx

title	description
USE DATABASE	The USE DATABASE statement tells SQLite Cloud to use the named database as the default (current) database for subsequent SQL statements

Syntax

USE DATABASE database_name

Privileges

PRIVILEGE_DBADMIN or PRIVILEGE_PUBSUB, which means that the USE DATABASE command succeeds if any of the following Privileges is set: PRIVILEGE_READ, PRIVILEGE_INSERT, RIVILEGE_UPDATE, PRIVILEGE_DELETE, PRIVILEGE_PRAGMA, PRIVILEGE_CREATE_TABLE, PRIVILEGE_CREATE_INDEX, PRIVILEGE_CREATE_VIEW, PRIVILEGE_CREATE_TRIGGER, PRIVILEGE_DROP_TABLE, PRIVILEGE_DROP_INDEX, PRIVILEGE_DROP_VIEW, PRIVILEGE_DROP_TRIGGER, PRIVILEGE_ALTER_TABLE, PRIVILEGE_ANALYZE, PRIVILEGE_ATTACH, PRIVILEGE_DETACH PRIVILEGE_SUB, PRIVILEGE_PUB

Description

The USE DATABASE statement tells SQLite Cloud to use the named database as the default (current) database for subsequent SQL statements.

Return

OK string or error value (see SCSP protocol).

Example

> USE DATABASE test.sqlite
OK