基本语法:create table * as (子查询),表示将子查询的结果以表的形式存储; 如果只需要复制表的结构,在条件语句中加入一个不成立的判断即可,如:create table constructofemp as select * from emp where 1=2;