SHOW VIEWS
描述
返回选择性指定的架构的所有视图。 此外，此语句的输出可以通过可选的匹配模式进行筛选。 如果未指定架构，则从当前架构返回视图。
语法
SHOW VIEWS [ { FROM | IN } schema_name ] [ [ LIKE ] regex_pattern ]参数
schema_name
指定架构名称。 如果未提供，则使用当前架构。
regex_pattern
用于筛除不需要的表的正则表达式模式。
- 除 * 和 | 字符外，该模式的工作方式类似于正则表达式。
- 只有 * 则匹配 0 个或多个字符，| 用于分隔多个不同的正则表达式，其中任何一个表达式都可以匹配。
- 在处理前，在输入模式中删除前导空格和尾随空格。 模式匹配不区分大小写。
示例
CREATE DATABASE rain_db1;
USE DATABASE rain_db1;
CREATE VIEW v1 as values(1);
CREATE VIEW v2 as values(2);
CREATE DATABASE rain_db2;
USE DATABASE rain_db2;
CREATE VIEW v3 as values(3);
CREATE VIEW v4 as values(4);
USE DATABASE rain_db2;
SHOW VIEWS;
+--------+---------+---------+----+--------------------+--------+-----------+
|database|tableName|tableType|size| createdAt|isShared|description|
+--------+---------+---------+----+--------------------+--------+-----------+
|rain_db2| v3| view| 0|2024-10-22 11:21:...| false| |
+--------+---------+---------+----+--------------------+--------+-----------+
|rain_db2| v4| view| 0|2024-10-22 11:21:...| false| |
+--------+---------+---------+----+--------------------+--------+-----------+
SHOW VIEWS FROM rain_db2;
+--------+---------+---------+----+--------------------+--------+-----------+
|database|tableName|tableType|size| createdAt|isShared|description|
+--------+---------+---------+----+--------------------+--------+-----------+
|rain_db2| t3| view| 0|2024-10-22 11:21:...| false| |
+--------+---------+---------+----+--------------------+--------+-----------+
|rain_db2| t4| view| 0|2024-10-22 11:21:...| false| |
+--------+---------+---------+----+--------------------+--------+-----------+
SHOW VIEWS IN rain_db1;
+--------+---------+---------+----+--------------------+--------+-----------+
|database|tableName|tableType|size| createdAt|isShared|description|
+--------+---------+---------+----+--------------------+--------+-----------+
|rain_db1| v1| view| 0|2024-10-22 11:21:...| false| |
+--------+---------+---------+----+--------------------+--------+-----------+
|rain_db1| v2| view| 0|2024-10-22 11:21:...| false| |
+--------+---------+---------+----+--------------------+--------+-----------+
SHOW VIEWS IN rain_db1 like '*1';
+--------+---------+---------+----+--------------------+--------+-----------+
|database|tableName|tableType|size| createdAt|isShared|description|
+--------+---------+---------+----+--------------------+--------+-----------+
|rain_db1| v1| view| 0|2024-10-22 11:21:...| false| |
+--------+---------+---------+----+--------------------+--------+-----------+