How to remove property from variant when deleted from code?

Vote:
 

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.

#205215
Jul 02, 2019 6:13
Vote:
 

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.

#205216
Jul 02, 2019 7:19
Vote:
 

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.

#205238
Jul 02, 2019 13:30
* You are NOT allowed to include any hyperlinks in the post because your account hasn't associated to your company. User profile should be updated.