Neoview SQL Reference Manual (R2.2)

SET SCHEMA Statement
• “Syntax Description of SET SCHEMA”
• “Consideration for SET SCHEMA”
• “Examples of SET SCHEMA”
The SET SCHEMA statement sets the default logical schema for unqualified object names for the
current SQL session.
SET SCHEMA default-schema-name
Syntax Description of SET SCHEMA
default-schema-name
specifies the name of the schema. See “Schemas” (page 247).
default-schema-name is an SQL identifier. For example, you can use MYSCHEMA or
myschema or a delimited identifier "my schema". See “Identifiers” (page 220).
Consideration for SET SCHEMA
The default schema you specify with SET SCHEMA remains in effect until the end of the session
or until you execute another SET SCHEMA statement.
Examples of SET SCHEMA
• Set the default schema name:
SET SCHEMA myschema;
SET SCHEMA Statement 163