单建表:
create table SEC_LOGIN_LOG_201203 as select * from SEC_LOGIN_LOG_201201 where 1=2
根据某些列建表:
create table so1.h_ins_prod1 as (select t1.h_id,t2.* from so1.h_ins_prod t1,so1.ins_prod t2 where 1=2);
单建表:
create table SEC_LOGIN_LOG_201203 as select * from SEC_LOGIN_LOG_201201 where 1=2
根据某些列建表:
create table so1.h_ins_prod1 as (select t1.h_id,t2.* from so1.h_ins_prod t1,so1.ins_prod t2 where 1=2);