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.