2 Replies Latest reply on Dec 13, 2012 5:03 PM by CloudDB

    copy indexes also while creating table

      is there any way i can take exact structure of table including indexes and create another table. i don't need the data.
      create table emp_copy as select * from emp where 1=2.
      this query creates only structure. how to copy indexes of emp also. Emp table has lot of indexes,unique indexes and functional based indexes. how can i take them to empy_copy. iPlease advice the query to copy indexes too.