Specifies the repository path name of a repository record
    definition. SQL creates the table using the definition from this
    record and gives the table the name of the record definition.

    You can create a table using the FROM path-name clause only if
    the record definition in the repository was originally created
    using the repository Common Dictionary Operator (CDO) utility.
    For instance, you cannot create a table using the FROM path-name
    clause if the record definition was created in the repository as
    part of an SQL session.

    If the repository record contains a nested record definition, you
    cannot create a table based on it.

    Creating a table based on a repository record definition is
    useful when many applications share the same definition. Changes
    to the common definition can be automatically reflected in all
    applications that use it.

                                   NOTE

       Changes by other users or applications to the record
       definition in the repository affect the table definition
       once the database is integrated to match the repository
       with an INTEGRATE DATABASE . . . ALTER FILES statement. If
       those changes include deleting records or fields on which
       tables or table columns are based, any data in the dependent
       table or table column is lost after the next INTEGRATE
       DATABASE . . . ALTER FILES statement executes.

    You can use the FROM clause only if the database was attached
    specifying PATHNAME. You can specify either a full repository
    path name or a relative repository path name.

    You cannot define constraints or any other table definition
    clauses, such as DATATRIEVE formatting clauses, when you use
    the FROM path-name form of the CREATE TABLE statement. This
    restriction does not prevent you from using an ALTER TABLE
    statement to add them later.

    You cannot use the FROM path-name clause when embedding a CREATE
    TABLE statement within a CREATE DATABASE statement.