![]() |
SQL-J Language Reference
|
Reference Manual |
SET SCHEMA statementThe SET SCHEMA statement sets the default schema for a connection's session to the designated schema. The default schema is used as the target schema for all statements issued from the connection that do not explicitly specify a schema name. The target schema must exist for the SET SCHEMA statement to succeed. See CREATE SCHEMA statement. If the schema is not specified, the default schema is set to the APP schema unless a user name was specified upon connection. If a user name was specified, the user's name is the default schema for the connection if a schema with that name exists. If one does not exist, the user defaults to the APP schema. The SET SCHEMA statement is not transactional: If the SET SCHEMA statement is part of a transaction that is rolled back, the schema change remains in effect. SyntaxSET SCHEMA SchemaName SET SCHEMA Examples
-- Create some objects in the hotel schema
-- Create a table in the hotel schema |
|
![]() Cloudscape Version 3.6 For information about Cloudscape technical support, go to: www.cloudscape.com/support/.Copyright © 1998, 1999, 2000 Informix Software, Inc. All rights reserved. |