Thank you @Werner Stinckens​ for your reply. However I still haven't managed to delete history even after setting the below. The number of history rows remains the same when running "DESCRIBE HISTORY".

SET spark.databricks.delta.retentionDurationCheck.enabled = false

What I am actually trying to do is removing older history records from delta table history. Moreover is there a minimum and maximum retention period you can have with time travel?