VastbaseE100

CREATE GLOBAL TEMPORARY TABLE

• 创建全局临时表，语法如下：

  Create Global Temporary Table Temp_Name
  (
  Col1 Type1,
  Col2 Type2
  ...
  )
  On Commit { Preserve | Delete }  Rows;
  

• 示例

  atlasdb=# Create Global Temporary Table Temp_tb1 ( id int) on commit delete rows;
  CREATE TABLE
  atlasdb=# insert into Temp_tb1 values (1);
  INSERT 0 1
  atlasdb=# select * from Temp_tb1;
  id 
  ----
  (0 rows)