1  –  ALIAS alias

    Specifies the alias for an attached database. The DROP DATABASE
    statement deletes the database and all database root and storage
    area files associated with the alias.

    If the database was declared with the PATHNAME argument, the DROP
    DATABASE statement also deletes the repository directory that
    contains the database definitions.

2  –  FILENAME

    Specifies a quoted string containing full or partial information
    needed to access a database. An attach specification contains the
    file specification of the .rdb file.

    The DROP DATABASE statement deletes the database and all
    database system files associated with the database root file
    specification. If you use a partial file specification, SQL uses
    the standard defaults. The DROP DATABASE statement deletes only
    the database files, whether or not there is also a repository
    directory containing database definitions.

3  –  literal-user-auth

    Specifies the user name and password for access to databases,
    particularly remote database.

    This literal lets you explicitly provide user name and password
    information in the DROP DATABASE statement.

4  –  PATHNAME

    Specifies a full or relative repository path name for the
    repository directory where the database definitions are stored.
    Use a path name instead of a file specification to delete the
    repository database definitions from the repository along with
    the database root and storage area files. See also the DROP
    PATHNAME statement.

5  –  USER username

    Defines a character string literal that specifies the operating
    system user name that the database system uses for privilege
    checking.

6  –  USING password

    Defines a character string literal that specifies the user's
    password for the user name specified in the USER clause.