You are here: Reference Information > SQL Reference Information > SQL Statements > USE

USE

USE — specify a schema

Syntax

USE schema_name

Description

USE specifies a schema as the default for the current connection to the NuoSQL client. If the schema does not exist, USE creates it (see CREATE SCHEMA).
A NuoDB database has one or more schemas. Each table, view, domain, index, and sequence is part of a particular schema. While you are using the default schema specified by the USE command, you can reference these objects with an unqualified name.
Use a qualified name to reference entities in schemas other than the default.

Parameters

Examples