@Dp15 - you can drop column manually using the below 

ALTER TABLE table_name DROP COLUMN col_name

1. Please note dropping a column from a metadata does not delete the underlying data for column in files.

2. Purging the data column can be done using REORG TABLE to rewrite files.

3. Use VACUUM to physically delete the files that contain the dropped column data.

Reference:

https://docs.databricks.com/en/delta/delta-column-mapping.html#drop-columns

https://docs.databricks.com/en/delta/update-schema.html#explicitly-update-schema-to-drop-columns