DISCONNECT CATALOG
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;
|
In this section:
