Schema Statements › SCHEMA Statement › Examples

Examples

Minimum SCHEMA statement

The following example supplies the minimum SCHEMA statement required for the purpose of later establishing a functional database:

add schema name is sampschm.

Using the TEXT clause to document schema revisions

In the following example, the DBA documents schema revisions and the purposes for those revisions; note that the DBA first defined REVISION NUMBER as a class in the dictionary with auto attributes.

modify schema name is culschem  version 6
    revision number is '6.5'
        text is 'accommodate new billing procedures'.

Note: For more information about the DISPLAY ALL statement, see Chapter 11, “Compiler-Directive Statements".