to create a table automatically

[saran]

i want to copy a whole table(say xxx) and insert into another table(say yyy).i want a query which create the table(yyy) automatically and copy from the table(xxx) because at the end, i will drop that table(yyy).Help me to write the query.


i tried like this but this doesnt work
insert into yyy select * from xxx;
This shows sqlException as "Could not find table yyy"

Thanks in advance.

 

[MStef]

1) You can run a "make table query" with "yyy" table,
and run an "append query" with "xxx" table,
and delete "yyy" table now.

2) You can benefit a "yyy" table, and run an "append query"
to append "xxx" table on "yyy" table.

 

[saran]

Thanks MStef .But actually i want to create a new table with structure of existing table in the program using query.So couldu explain it thru query