1 2 ALTER VIEW [ IF EXISTS ] view_name SET SCHEMA new_schema; 设置视图的选项。 1 2 ALTER VIEW [ IF EXISTS ] view_name SET ( { view_option_name

查看更多 →

REPLACE ] [ TEMP | TEMPORARY ] VIEW view_name [ ( column_name [, ...] ) ] [ WITH ( {view_option_name [= view_option_value]} [, ... ] ) ]

查看更多 →

设置视图的所属模式。 ALTER VIEW [ IF EXISTS ] view_name SET SCHEMA new_schema; 设置视图的选项。 ALTER VIEW [ IF EXISTS ] view_name SET ( { view_option_name

查看更多 →

EXISTS ] view_name SET SCHEMA new_schema; 设置视图的选项。 1 2 ALTER VIEW [ IF EXISTS ] view_name SET ( { view_option_name [ = view_option_value

查看更多 →

REPLACE ] [ TEMP | TEMPORARY ] VIEW view_name [ ( column_name [, ...] ) ] [ WITH ( {view_option_name [= view_option_value]} [, ... ] ) ]

查看更多 →

REPLACE ] [ TEMP | TEMPORARY ] VIEW view_name [ ( column_name [, ...] ) ] [ WITH ( {view_option_name [= view_option_value]} [, ... ] ) ]

查看更多 →

EXISTS ] view_name SET SCHEMA new_schema; 设置视图的选项。 1 2 ALTER VIEW [ IF EXISTS ] view_name SET ( { view_option_name [ = view_option_value

查看更多 →

REPLACE ] [ TEMP | TEMPORARY ] VIEW view_name [ ( column_name [, ...] ) ] [ WITH ( {view_option_name [= view_option_value]} [, ... ] ) ]

查看更多 →

1 2 ALTER VIEW [ IF EXISTS ] view_name SET SCHEMA new_schema; 设置视图的选项。 1 2 ALTER VIEW [ IF EXISTS ] view_name SET ( { view_option_name

查看更多 →

取值范围：字符串，符合标识符命名规范。 view_option_name [= view_option_value] 该子句为视图指定一个可选的参数。 目前view_option_name支持的参数仅有security_barrier，当VIEW试图提供行级安全时，应使用该参数。 取

查看更多 →

CREATE VIEW 本章节介绍如何在ClickHouse中创建普通视图。 创建视图 CREATE VIEW [IF NOT EXISTS] [db.]view_name [ON CLUSTER ClickHouse集群名] AS SELECT ... 表1 参数说明 参数 说明

查看更多 →

1 2 ALTER VIEW [ IF EXISTS ] view_name SET SCHEMA new_schema; 设置视图的选项。 1 2 ALTER VIEW [ IF EXISTS ] view_name SET ( { view_option_name

查看更多 →

1 2 ALTER VIEW [ IF EXISTS ] view_name SET SCHEMA new_schema; 设置视图的选项。 1 2 ALTER VIEW [ IF EXISTS ] view_name SET ( { view_option_name

查看更多 →

REPLACE ] [ TEMP | TEMPORARY ] VIEW view_name [ ( column_name [, ...] ) ] [ WITH ( {view_option_name [= view_option_value]} [, ... ] ) ]

查看更多 →

CREATE VIEW语句 语法定义 CREATE VIEW [IF NOT EXISTS] view_name [{columnName [, columnName ]* }] [COMMENT view_comment] AS query_expression 功能描述

查看更多 →

CREATE VIEW语句 语法定义 CREATE VIEW [IF NOT EXISTS] view_name [{columnName [, columnName ]* }] [COMMENT view_comment] AS query_expression 功能描述

查看更多 →

GS_VIEW_INVALID GS_VIEW_INVALID视图提供查询当前用户可见的所有不可用的视图。如果该视图依赖的基础表或函数或同义词存在异常，该视图validtype列显示为“invalid”。 表1 GS_VIEW_INVALID字段 名称 类型 描述 oid oid

查看更多 →

openGauss=# DROP MATERIALIZED VIEW my_mv; 相关链接 ALTER MATERIALIZED VIEW，CREATE INCREMENTAL MATERIALIZED VIEW，CREATE MATERIALIZED VIEW，CREATE TABLE，REFRESH

查看更多 →

MATERIALIZED VIEW，CREATE INCREMENTAL MATERIALIZED VIEW， CREATE MATERIALIZED VIEW，CREATE TABLE，REFRESH INCREMENTAL MATERIALIZED VIEW，REFRESH MATERIALIZED

查看更多 →

DROP MATERIALIZED VIEW my_mv; 相关链接 ALTER MATERIALIZED VIEW，CREATE INCREMENTAL MATERIALIZED VIEW， CREATE MATERIALIZED VIEW，CREATE TABLE，REFRESH

查看更多 →

CREATE VIEW语句 功能描述 根据给定的 query 语句创建一个视图。如果数据库中已经存在同名视图会抛出异常。 语法定义 CREATE [TEMPORARY] VIEW [IF NOT EXISTS] [catalog_name.][db_name.]view_name

查看更多 →