----------  Create or Drop Schema  ----------

The "create schema" command creates a schema in the database.  

Syntax:

 create schema  [SCHEMA] 
                [authorization USER] 
		[noshmem|shmem]  [nolock|lock]  [cipher=<CIPHER>]
                [SCHEMA-ELEMENT-LIST];
 
At least one of [SCHEMA] and [authorization USER] must appear.

If the [SCHEMA] specification is omitted, then the USER value from 
[authorization USER] is taken as the schema name.

SCHEMA-ELEMENT-LIST can be a combination of:
                | create table command    |
                | create view command     |

A create view statement in SCHEMA-ELEMENT-LIST can create a view that is based
on a table that is created by a later create table statement.

To remove a schema, its definition, and ALL its contents from the database, the
"drop schema" command is used.

Syntax:

     drop schema SCHEMA { restrict | cascade };

If restrict is specified, the operation will fail if the specified SCHEMA is
nonempty; otherwise it will succeed, and the schema will be destroyed.

If cascade is specified, the operation will always succeed, and will cascade 
to drop not only the specified schema itself, but also all objects contained
in that schema.

For further information on display schema information, enter:

                help display;
