I have table
emp and I want to create a duplicate table from the
emp table. I tried the below query, which is copying all the table columns, data and the not null constraints.
create table emp_backup as select * from emp.
Is there any way to duplicate a table along with all constraints?
Here is the base table:
create table emp ( empno number Primary key, ename varchar2(50), deptno number, constraint emp_deptno_fk foreign key(deptno) references dept(deptno) )
I need to create a table emp_backup from the emp along with emp_deptno_fk constraint.