Use the SHOW CATALOGS statement to obtain a list of available database catalogs. The command returns a list of available catalog information with catalog name, catalog type (primary or auxiliary), and catalog status (default or notdefault).
The SHOW CATALOGS statement uses the following syntax:
SHOW CATALOGS [ ALL |{ PRO_NAME | PRO_TYPE | PRO_STATUS }][ , PRO_NAME | PRO_TYPE | PRO_STATUS }];
The following example demonstrates the use of the SHOW CATALOGS statement.
SHOW CATALOGS PRO_NAME;
The SHOW CATALOGS statement is useful for obtaining the catalog names of databases currently connected for the user, for identifying the catalog name of the primary database and the current default catalog. Three columns of information can be returned by the SHOW CATALOGS statement and they describe the catalog's name, type (primary or auxiliary), and status (default or not default).
For more information on the SHOW CATALOG statement, see OpenEdge Data Management: SQL Reference.
