Hi All
I found that following sql will create a copy, but with same sequence table.
CREATE TABLE tablename (LIKE oldtablename INCLUDING DEFAULTS);

But I want to create new empty table copy of existing table with new sequence or copy of existing sequence.

Is anyone know how to create empty table copy of existing table like this.

What is sequence table?

After you create your new table, you'll have to manually create a new sequence and make that the default value of your column. So unless there are other default column values you're trying to copy, omit WITH DEFAULTS from your statement.

Thanks futurity!

This is for solution for backup table which contain millions of records. By this I can rename the table and make a new table. Hope it is better to do this way, than copying to a new table.