I would like to add a new column(allow null) to CMP, but I have some data in the table. If i have CMP recreate a table, then it deletes all data from the table. is there any way to add a new column to the table without losing data? should I just add a new property to CMP and add a new column to a table manually?
use alter-table tag, see wiki