copy the table schema HELP???

Greetings,



I am using a select into statement to copy the data fileds from a master table to a user table, this works well but I now need help figuring out how to copy the table schema from one table to another.





Thanks,

??? Why would you want that ??? I does not make sens at all.

Your table is defined already. You cannot apply a table schema to a table you can just read it out.

If you need different tables then create them dynamically with CREATE TABLE