数据仓库服务 GAUSSDB(DWS)-DROP VIEW:示例

时间：2024-01-26 16:15:18

示例

删除视图myView：

  
       DROP VIEW myView;

删除视图customer_details_view_v2：

  
       DROP VIEW public.customer_details_view_v2;

重建分区表customer_address分区P1的分区索引：

DROP TABLE IF EXISTS customer_address;
CREATE TABLE customer_address
(
    ca_address_sk       INTEGER                  NOT NULL   ,
    ca_address_id       CHARACTER(16)            NOT NULL   ,
    ca_street_number    CHARACTER(10)                       ,
    ca_street_name      CHARACTER varying(60)               ,
    ca_street_type      CHARACTER(15)                       ,
    ca_suite_number     CHARACTER(10)                    
)
DISTRIBUTE BY HASH (ca_address_sk)
PARTITION BY RANGE(ca_address_sk)
(
        PARTITION P1 VALUES LESS THAN(2450815),
        PARTITION P2 VALUES LESS THAN(2451179),
        PARTITION P3 VALUES LESS THAN(2451544),
        PARTITION P4 VALUES LESS THAN(MAXVALUE)
);

CREATE INDEX customer_address_index on customer_address(CA_ADDRESS_SK) LOCAL;

REINDEX TABLE customer_address PARTITION P1;

上一篇：数据仓库服务 GAUSSDB(DWS)-时间/日期函数:adddate(date, interval | int)

下一篇：数据仓库服务 GAUSSDB(DWS)-SAVEPOINT:示例