If the table is empty, just rename the table. Then get the DDL: "CREATE TABLE ...". Correct the table name in the statement as well as the default value and execute that statement. Finally drop the renamed table.