HANA中复制表结构及其数据

复制表结构及其数据

CREATE TABLE table_name_new AS ( SELECT * FROM table_name_old )

只复制表结构：

CREATE TABLE table_name_new AS ( SELECT * FROM table_name_old ) WITH NO DATA

或者：

CREATE TABLE table_name_new LIKE table_name_old

只复制表数据：

如果两个表结构一样：

INSERT INTO table_name_new SELECT * FROM table_name_old

如果两个表结构不一样：

INSERT INTO table_name_new(column1,column2...) SELECT column1,column2... FROM table_name_old