Modifying Schema, View, Table, and Routine Definitions › Maintaining Schemas › Modifying a Schema

Modifying a Schema

To modify a schema, use the SQL DDL ALTER SCHEMA statement.

Considerations

Changing the default area associated with the schema does not affect existing tables.

Example

In the following example, the schema's default area is changed.

alter schema demoempl
   default area demoempl.emplarea;