create table emp1 as select * from emp where 1=2

but my question how about the constraints , the above query not copied the constrains
that are assigned to the emp table

zamary shahab...