I wish to create a new table using the structure from an existing table. I don't want to use the Create statement all over again for the new table. I believe the syntax goes something like this:
create new_table_name from select * from old_table_name where 0 = 1
but I am not really sure.