Description

DESC CATALOG is a SQL command used to display detailed information about a specific catalog. Using this command, users can obtain a detailed description of the catalog, including its creation time, creator, and other information.

Syntax

DESC CATALOG [EXTENDED] catalog_name;

Parameter Description

• catalog_name: The name of the catalog to be described. The user must ensure that the provided catalog name exists and is accessible in the system.

Example

DESC CATALOG test_external_catalog; +--------------------+------------------------+ | info_name | info_value | +--------------------+------------------------+ | name | test_external_catalog | | creator | UAT_TEST | | created_time | 2024-06-27 18:05:36.69 | | last_modified_time | 2024-06-27 18:05:36.69 | | comment | | +--------------------+------------------------+