SQL allows you to specify an alias that declares the database as
the default database. Specifying a default database means that
subsequent statements during the database attachment that refer
to the default database need not use an alias.
In the SQL module language, the alias specified in the module
header is the one that designates the default database. In
precompiled SQL programs and in interactive SQL, the special
alias RDB$DBHANDLE designates the default database. In all
environments, omitting an explicit alias is the same as
specifying the alias that designates the default database.
Select More_Information to continue.
1 – More Information
If you do not declare any alias or attach to any database, SQL
declares the database specified in the logical name SQL$DATABASE
or configuration parameter SQL_DATABASE as the default database,
using the FOR FILENAME clause.
If you declare a database specifying an alias other than the
one that declares the default database, you must use that alias
to qualify names of any database elements to which you refer in
SQL statements. If you omit the alias, SQL assumes the table or
view must be part of the default database. If there is no default
database and you omit the alias, SQL generates an error.