Sometimes we need to remove the Attribute from already build Configurable product. As it seem like a slightly tough process, it is yet achievable by removing it from MYSQL Raw Query. Although it is against the ‘Standard’ but works like a charm when required.
To remove one super product attribute (as they are called) from all configurable products, you can execute this SQL query in the database:
DELETE FROM catalog_product_super_attribute WHERE attribute_id = “attribute ID which should be removed”
The table catalog_product_super_attribute links products to super product attributes. You can add and remove attributes to created configurable products there.