FINISH ;

Additional information available:

More Information

 FINISH detaches from declared schemas and frees the
 authorization identifiers used by the declarations.

 You cannot dynamically execute a FINISH statement.

 FINISH allows you to declare a schema with the same
 authorization identifier as a previously declared schema.  In
 this example, the authorization identifier is the default.  For
 example:

 SQL> SHOW SCHEMA
 Default schema:
     Rdb/VMS database in file FOO

 SQL> DECLARE SCHEMA FILENAME SQL$DATABASE;
 This authorization identifier has already been declared.
 Would you like to override this declaration (No)? NO
 %SQL-F-DEFDBDEC, A schema has already been declared with
         the default authorization identifier
 SQL> FINISH;
 SQL> DECLARE SCHEMA FILENAME SQL$DATABASE;
 SQL> SHOW SCHEMA
 Default schema:
     Rdb/VMS database in file SQL$DATABASE