How to remove property from variant when deleted from code? I don't want to just unlink but I want to remove from tables like ecfVersionProperty and CatalogContentproperty. I am not sure if a query to delete form both tables does not break anything and works properly. I am using Commerce of version 13.2.
There is no such query, and we recommend against deleting data directly. In this case I suggest to leave them as is, they would not affect performance anyway.
I agree it won't make any impact on perforamance. However, I have cases where property name is already occupied by previously deleted names. And there are so many properties which are difficult to read and time consumingl.