A part of the attach expression that specifies a name for the attach to the database. Specifying an alias lets your program or interactive SQL statements refer to more than one database. You do not have to specify an alias in the ATTACH statement. 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 ATTACH statement or by omitting any alias) makes the database part of the default environment. Specifying a default database means that statements that refer to that database do not need to use an alias. If a default alias was already declared, and you specify the default alias in the alias clause (or specify any alias that was already declared), interactive SQL issues an informational message. In the following example, TESTDB is the first database attached and uses the default alias. When no alias is specified for the second database attached, SQL tries to assign it the default alias but finds that the default alias is already declared. SQL> ATTACH 'FILENAME testdb'; SQL> ATTACH 'FILENAME otherdb'; This alias has already been declared. Would you like to override this declaration (No)? N SQL-F-DEFDBDEC, A database has already been declared with the default alias SQL> SHOW DATABASES; Default alias: Oracle Rdb database in file testdb SQL> ATTACH 'FILENAME otherdb'; This alias has already been declared. Would you like to override this declaration (No)? Y SQL> SHOW DATABASES; Default alias: Oracle Rdb database in file otherdb