DISCONNECT ---+-> connection-name ---+-> ;
               +-> ALL ---------------+
               +-> CURRENT -----------+
               +-> DEFAULT -----------+

Additional information available:

ALLCURRENTDEFAULT

connection-nameMore Information

 A simple value expression that specifies a list of databases.  The
 connection name must be enclosed in single quotation marks.

 Specifies all active connections.

 Specifies the current connection.

 Specifies the default connection.

 DISCONNECT detaches from declared schemas, releases the aliases used
 by the declarations, and undoes all the changes that you made since
 those transactions began.

                                 NOTE

         Because DISCONNECT includes an automatic ROLLBACK,
         you should COMMIT any changes you wish to keep before
         issuing the DISCONNECT statement.


 DISCONNECT allows you to declare a database with the same alias as a
 previously declared database.  In this example, the alias is the
 default.  For example:

 $ DEFINE SQL$DATABASE DISK01:[DEPT32]FOO
 $ SQL
 SQL> ATTACH 'FILENAME FOO';
 SQL> SHOW DATABASE
 Default alias:
     Rdb/VMS database in file FOO

 SQL> ATTACH 'FILENAME SQL$DATABASE';
 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
 SQL> DISCONNECT DEFAULT;
 SQL> ATTACH 'FILENAME SQL$DATABASE';
 SQL> SHOW DATABASE
 Default alias:
     Rdb/VMS database in file SQL$DATABASE