Toad World® Forums

New column or add one more column

hello,
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
:slight_smile:

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.