【GBase 8a MPP数据库集群】修改视图 ALTER VIEW

最新推荐文章于 2023-12-22 14:21:47 发布

zxnkiss87

最新推荐文章于 2023-12-22 14:21:47 发布

阅读量286

点赞数

分类专栏： GBase 文章标签：数据库 database dba sql

本文链接：https://blog.csdn.net/zxnkiss87/article/details/126049250

版权

GBase 专栏收录该内容

49 篇文章 1 订阅

订阅专栏

语法格式

ALTER VIEW [VCNAME.][database_name.]view_name [(column_list)] AS select_statement

示例

修改视图 v_t 中的列为指定列：

gbase> DESC v_t;
+---------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------+--------------+------+-----+---------+-------+
| name | varchar(20) | YES | | NULL | |
| address | varchar(40) | YES | | NULL | |
| sex | int(11) | YES | | NULL | |
+---------+--------------+------+-----+---------+-------+
3 rows in set
gbase> ALTER VIEW test.v_t(a, b) AS SELECT name,address FROM t;
Query OK, 0 rows affected
gbase> DESC v_t;
+-------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+--------------+------+-----+---------+-------+
| a | varchar(20) | YES | | NULL | |
| b | varchar(40) | YES | | NULL | |
+-------+--------------+------+-----+---------+-------+
2 rows in set
gbase> SELECT * FROM v_t;
+------+-----------------------+
| a | b |
+------+-----------------------+
| TOM | east street |
| jack | west road NO 15 |
| MIKE | DongFang road NO 22 |
| TONY | EA Street |
| Rose | TangRen Street NO.191 |
+------+-----------------------+
5 rows in set