云数据库 GAUSSDB-TRUNCATE:语法格式

时间:2024-11-02 18:50:37

语法格式

  • 清理表数据。
TRUNCATE [ TABLE ] [ ONLY ] {table_name [ * ]} [, ... ]
    [ CONTINUE IDENTITY ] [ CASCADE | RESTRICT] [ PURGE ]};
  • 清理表分区的数据。
ALTER TABLE [ IF EXISTS  ] { [ ONLY  ] table_name  
                           | table_name *  
                           | ONLY ( table_name )  } 
    TRUNCATE PARTITION { partition_name  
                       | FOR (  partition_value  [, ...] )  } [ UPDATE GLOBAL INDEX ];
support.huaweicloud.com/centralized-devg-v3-gaussdb/gaussdb-12-0652.html