Try OpenEdge Now
skip to main content
SQL Reference
SQL Reference : OpenEdge SQL Statements : SHOW CATALOGS
 

SHOW CATALOGS

Returns a list of available catalog information with catalog name, catalog type (primary or auxiliary), and catalog status (default or not default).

Syntax

SHOW CATALOGS [ ALL |{ PRO_NAME | PRO_TYPE | PRO_STATUS }  
              [ , PRO_NAME | PRO_TYPE | PRO_STATUS } ;

Parameters

ALL
Return all attributes.
PRO_NAME
List of catalog names.
PRO_TYPE
List of catalog types (primary or auxiliary).
PRO_STATUS
List of catalog statuses (default or notdefault)

Notes

*This statement is useful for obtaining the catalog names of databases currently connected for the user, for identifying the catalog name of the primary database (automatically connected) and the current default catalog.
*The primary database connection is automatically given a catalog name which is the name of the primary database. For example, if the database is at /usr/progress/sports2000, then the catalog name for the primary database is sports2000.
*Three columns of information are returned by the SHOW CATALOG statement. These are the catalog name, catalog type (primary or auxiliary) and status (default or notdefault).

Example

In this example, the names of the currently available catalogs are returned.
SHOW CATALOGS PRO_NAME;
* Authorization
* SQL Compliance
* Related statements