![]() |
SQL-J Language Reference
|
Reference Manual |
CREATE SCHEMA statementA schema is a way to logically group objects in a single collection and provide a unique namespace for objects. SyntaxCREATE SCHEMA SchemaName The CREATE SCHEMA statement is used to create a schema. Schema names must be unique within the database. You must create a schema with a CREATE SCHEMA statement before referring to it, unless the schema is the APP or SYS schema. CREATE SCHEMA Examples
-- Create a schema for hotel-related tables
-- Create a schema for airline-related tables
-- Create a table called "Availability" in each schema
CREATE TABLE Hotels.Availability |
|
![]() 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. |