如何查看H2数据库中的当前模式搜索路径? [英] How to view current schema search path in a h2 database?

问题描述

连接到h2数据库时，默认搜索路径设置为public. 您可以使用SET SCHEMA_SEARCH_PATH进行更改.

When connecting to an h2 database, the default search path is set to public. You can alter it with the SET SCHEMA_SEARCH_PATH.

但是如果您多次更改它，在某个时候如何查看其当前内容?

But if you alter it multiple times, at some point how can you view its current content?

我找不到类似VIEW SCHEMA_SEARCH_PATH或SHOW SCHEMA_SEARCH_PATH这样的命令.

I wasn't able to find some kind of commands like this VIEW SCHEMA_SEARCH_PATH or SHOW SCHEMA_SEARCH_PATH.

键入它们会给我错误消息.

Typing them give me error messages.

推荐答案

有点hack，但是您可以使用:

It's a bit a hack, but you could use:

SELECT * FROM INFORMATION_SCHEMA.SESSION_STATE 
WHERE KEY='SCHEMA_SEARCH_PATH'

这篇关于如何查看H2数据库中的当前模式搜索路径?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！