Copying table: data, structure, AND indexes

How would you copy a table including its indexes? Currently, I use

        create table new_table as select * from old_table; but this only creates new_table with the same structure as old_table containing old_table's data. old_table's indexes are not created with new_table.

Appreciate your thoughts on this. Please email me at:

doknjas_at_netpointer.com Received on Wed Jul 23 1997 - 00:00:00 CDT