You need to rename, instead of dropping and recreating the column.