Name
CREATE SCHEMA
Synopsis
CREATE SCHEMA AUTHORIZATIONschema
[CREATE TABLEstatement
] [CREATE VIEWstatement
] [GRANTstatement
]
Creates multiple tables and/or views and issues grants in a single statement.
Tip
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.
Keywords
- schema
Name of the schema to be created, which must be the same as your username.
- CREATE TABLE statement
This is a CREATE TABLE statement, as shown later in the CREATE TABLE entry.
- CREATE VIEW statement
This is a CREATE VIEW statement, as shown later in the CREATE VIEW entry.
- GRANT statement
This is a GRANT statement, as shown later in the GRANT entry.
Get Oracle in a Nutshell now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.