how to remove the deployments which are not in use?

[Former Member]

i was using some itemtypes for which i made some deployments. now as that extension is not in use anymore, i have to remove all the deployments related to that extension. i tried removing the extension from the localextensions.xml file, then fired an ant clean all updatesystem clearOrphanedTypes command. now when i am starting the server, itemtypes and their deployment are not shown under the maintainence/deployment tab but are shown under the database tab when i am calculating table sizes. How to remove the complete trace of that extension?

[arvind-kumar_avinash · Accepted solution]

Hi - please note that system update does not remove any table or column from a table in the database. Please go through https://help.hybris.com/1811/hcd/08c89599782a4d589a2d5651899d02f1.html for more information.

There are only two ways to remove any table or column from a table in the database after you have removed their references from items.xml:

1. Perform system initialization - as we all know, it will delete all tables from the database and recreate them based on the items.xml files of all the applicable extensions. It is the reason, we do not apply it on a system with business data (e.g. the production system or any other system where we have real business data). We do it only on a system with dummy/test data.

2. Drop the tables and columns directly in the database.

[mpern]

drop the table directly in the database.

the type system only removes the meta data (that's why they are removed from maintenance/deployment), but never removes tables from the database. (FYI, the same goes for columns in the table for removed attributes...)