SHOW CREATE CATALOG
Description
This statement shows the creating statement of a doris catalog.
Syntax
SHOW CREATE CATALOG <catalog_name>;Required Parameters
1. <catalog_name>
The name of the catalog whose creation statement needs to be viewed.
Access Control Requirements
| Privilege | Object | Notes |
|---|---|---|
| ADMIN_PRIV / SELECT_PRIV / LOAD_PRIV / ALTER_PRIV / CREATE_PRIV / SHOW_VIEW_PRIV / DROP_PRIV | Catalog | One of the above permissions is required. |
Example
-
View the creating statement of the oracle catalog in doris
SHOW CREATE CATALOG oracle;+---------+----------------------------------------------------------------------------------------------------------------------+ | Catalog | CreateCatalog | +---------+----------------------------------------------------------------------------------------------------------------------+ | oracle | CREATE CATALOG `oracle` PROPERTIES ( "user" = "XXX", "type" = "jdbc", "password" = "*XXX", "jdbc_url" = "XXX", "driver_url" = "XXX", "driver_class" = "oracle.jdbc.driver.OracleDriver", "checksum" = "XXX" ); | +---------+----------------------------------------------------------------------------------------------------------------------+