database - Export and import to a different schema -

Is there a way in which I can export table entries, delete a colon from the table, Can I import back table?

The opposite case works fine - adding a column is not problematic (if the column is tap).

Thanks