Removes a connection to an auxiliary read-only database.

Syntax

DISCONNECT CATALOG catalog_name;

Parameter

catalog_name

Catalog name to be used as an alias for the database in schema, table and column references. This must be in the form of an SQL identifier.

Notes

Used to remove auxiliary connections established by executing the CONNECT AS CATALOG statement.

Example

In this example, the auxiliary database connection identified by the catalog named mydb1 is removed:

DISCONNECT CATALOG mydb1;