Question

db2中可以实现create table A as select * from B吗

Answer 1

好像不行，可以用两条命令完成 create table a like b insert into a select * from 实例讲解DB2数据库中SELECT语句高级用法 1、创建结果表 create table new_table_name as (select * from table_name) definition only; 2、创建物化查询表（MQ...

Answer 2

create table A as (select * from B) definition only;