December 2002
Intermediate to advanced
928 pages
85h 29m
English
CREATE SCHEMA
CREATE SCHEMA AUTHORIZATIONschema[CREATE TABLEstatement] [CREATE VIEWstatement] [GRANTstatement]
Creates multiple tables and/or views and issues grants in a single statement.
You must have the same privileges required for the CREATE TABLE, CREATE VIEW, and GRANT statements to issue this statement. Individual statements within the CREATE SCHEMA statement must not be terminated with the SQL termination character.
Name of the schema to be created, which must be the same as your username.
This is a CREATE TABLE statement, as shown later in the CREATE TABLE entry.
This is a CREATE VIEW statement, as shown later in the CREATE VIEW entry.
This is a GRANT statement, as shown later in the GRANT entry.