SQL$HELP72.HLB  —  CREATE  DATABASE  Arguments  alias
    Specifies the alias for the implicit database declaration
    executed by the CREATE DATABASE statement. An alias is a name for
    a particular attach to a database that identifies that database
    in subsequent SQL statements.

                                   NOTE

       If you attach to a database using an alias, you must use
       that alias in subsequent statements to qualify the names of
       elements in that database.

    If you omit the FILENAME argument from the database root file
    parameters, SQL also uses the alias as the file name for the
    database root file and creates the root file in the current
    default directory. (SQL generates a syntax error if you include
    a disk or directory specification in the alias clause.) You must
    specify either the FILENAME or alias argument.

    Schema elements in the CREATE DATABASE statement do not need to
    use the alias, however, they cannot specify any other alias.

    The alias clause is optional. The default alias in interactive
    SQL and in precompiled programs is RDB$DBHANDLE. In the SQL
    module language, the default is the alias specified in the
    module header. Using the default alias (either by specifying
    it explicitly in the ALIAS clause or omitting the ALIAS clause)
    declares the database as the default database. Specifying a
    default database means that statements outside the CREATE
    DATABASE statement that refer to the default database do not
    need to use an alias.

    If a default database was already declared, and you specify the
    default alias in the ALIAS clause (or specify any alias that was
    already declared), the results depend on the environment in which
    you issue the CREATE DATABASE statement.

    o  In interactive SQL, you receive a prompt asking if you want
       to override the default database declaration. Unless you
       explicitly override the default declaration, the CREATE
       DATABASE statement fails.

       SQL> -- Assume a default database has been declared:
       SQL> --
       SQL> -- Now create a database without an alias.
       SQL> -- SQL asks if you want to override the default:
       SQL> CREATE DATABASE FILENAME test;
       This alias has already been declared.
       Would you like to override this declaration (No)? NO
       %SQL-F-DEFDBDEC, A database has already been declared with the default
       alias

    o  In embedded SQL or in the SQL module language, specifying
       an already-declared alias in the CREATE DATABASE statement
       generates an error when you precompile the program or compile
       the module.

    o  In dynamic SQL, specifying an already-declared alias overrides
       the earlier declaration.

    For more information about default databases, see the User_
    Supplied_Names HELP topic.
Close Help