AntDB 数据库参考指南-SQL语法 / DDL语句5

DROP TABLE

说明：

移除一个表

语法：

DROP TABLE [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]

示例：

--移除department和company两张表，若表格不存在，会报错
DROP TABLE department, company;

--移除department表，即使表格不存在，也会报错
DROP TABLE IF EXISTS department;

CREATE VIEW

说明：

定义一个新视图

语法：

CREATE [ OR REPLACE ] [ TEMP | TEMPORARY ] [ RECURSIVE ] VIEW name [ ( column_name [, ...] ) ]
    [ WITH ( view_option_name [= view_option_value] [, ... ] ) ]
    AS query
    [ WITH [ CASCADED | LOCAL ] CHECK OPTION ]

示例：

--创建一个基于表格COMPANY的视图COMPANY_VIEW
CREATE VIEW COMPANY_VIEW AS SELECT ID, NAME, AGE FROM COMPANY;