generate the schema for the table you want to clone, change the table-name and index-name(s) in the SQL script, and create a new table that will have exactly the same structure as the original table.
from the commandline execute this:
dbschema -d database_name -t table_name > build_table.sql
then edit the build_table.sql script as previously described and run it.
use you favorite SQL tool (like dbaccess) and execute this:
insert into new_table (col1, col2, col3, col4, col5, col6)
select (col1, col2, col3, col4, col5, col6)
suggestion if the table is huge:
1) execute the "create table" statement in build_table.sql to create the new table
2) insert data into the new table from the original table as described
3) execute the "create index" statement(s) in build_table.sql