Categories:

Context functions (Session Object)

CURRENT_WAREHOUSE¶

返回当前会话使用的仓库的名称。

To specify a different warehouse for the session, execute the USE WAREHOUSE command.

语法

CURRENT_WAREHOUSE()

实参

无。

示例

显示当前仓库、数据库和架构：

Copy codeExpand code block

SELECT CURRENT_WAREHOUSE(), CURRENT_DATABASE(), CURRENT_SCHEMA();

Show lessSee more

Scroll to top

输出：

Copy codeExpand code block

+---------------------+--------------------+------------------+
| CURRENT_WAREHOUSE() | CURRENT_DATABASE() | CURRENT_SCHEMA() |
|---------------------+--------------------+------------------|
| DEV_WAREHOUSE       | TEST_DATABASE      | UDF_TEST_SCHEMA  |
+---------------------+--------------------+------------------+

Show lessSee more

Scroll to top