Toad World® Forums

New column or add one more column

It is possible from an existing table to create another similar table with one more field and with records. Without occupying alter.
Thank a lot

Sure. In the editor, run this:

Create new_table_name as select * from old_table_name;

then alter new_table_name and add whatever columns you want.

Or you can change the select however you want to include additional columns.