The user has first to save the existing data to a temporary table. Then, then drop the old column or table, create a new table and copy the data back that put in the temporary table. The support for the altar table is minimal.

BY Best Interview Question ON 09 Feb 2019