alter database

Alter the definition of a database (schema)

Syntax

alter_schema:
          ALTER {DATABASE | SCHEMA} {database_name | DEFAULT}

Description

An ALTER DATABASE/SCHEMA initiates a schema DDL change on the specified database or, if DEFAULT is specified, the name derived from the file name containing the DDL statements that define the DDL changes that is submitted to the rdm-compile utility.

A database version number is maintained in the catalog. This version number is incremented when the DDL changes defined by the subsequent DDL statements are committed producing a new version of the database catalog.

If this statement is submitted through SQL, the changes will be incorporated into the database when a COMMIT statement is executed.