Let's say it can be a requirement to ressurect a relational table with a dynamic structure to get a working copy.
One can avoid this situation by introducing a meta-meta-layer to a data model, but you need the skills and the chance to do so.
There are other ways to achieve this (e.g. replication), but we do Kettle here.
So here is another way to go:
(1) Write a DROP TABLE statement to a file
(2) Append the necessary DDL statement
(3) Append the INSERT INTO statement for each data row
(4) Process the SQL-file one statement per row
To automate the whole process a job is needed.
OpenJDK IcedTea 2.3.7 (7u21)
ubuntu 12.04 LTS (x86_64)