SQL$HELP_OLD72.HLB  —  User Supplied Names, Multischema Databases
    If you specify the multischema attribute for your database,
    you can store data definitions in multiple schemas within
    that database. To specify the multischema attribute, use the
    MULTISCHEMA IS ON clause in a CREATE DATABASE or ALTER DATABASE
    statement. If you want SQL behavior compliant with the ANSI/ISO
    standard, you must specify the multischema attribute.

    Databases that contain multiple schemas must organize the schemas
    within one or more catalogs. To refer to data definitions in a
    multischema database, qualify the names of data definitions with
    the schema and catalog names and, optionally, qualify with an
    alias.

    When you use an alias to qualify the name of a catalog, schema,
    or object in a multischema database:

    o  Separate subordinate names from the alias and from each other
       with a period (.)  after each name.

    o  Use double quotation marks (")  to delimit the leftmost name
       pair.

    o  Use only uppercase characters in the leftmost name pair.

    The leftmost name pair in a qualified name for a multischema
    object is a delimited identifier. In an object name, each
    qualifying name is considered one level, and names with more than
    three levels are not allowed. However, a delimited identifier is
    interpreted as a single level.
Close Help