How to delete a Maximo application

Maximo does not allow to delete applications from the Application Designer. However, there is a trick well hidden in the Application Developer Guide to accomplish this task using a SQL client. Note that only user defined application should be deleted. Out-of-the-box applications can be hidden using the standard Maximo security mechanism.

It is better to backup the Maximo database and shut down the application server before proceeding.
To delete an application complete the following steps:

1. Open an SQL client and connect to MAXIMO database.
2. Type the following commands, replacing the variable with the name of the application you want to delete. Enter the application name in all uppercase. For example, if the name of the application you want to delete is TEST, replace APPNAME with TEST in all the commands.

delete from maxapps         where app='APPNAME';
delete from maxpresentation where app='APPNAME';
delete from sigoption       where app='APPNAME';
delete from applicationauth where app='APPNAME';
delete from maxlabels       where app='APPNAME';
delete from maxmenu         where moduleapp='APPNAME' and menutype!='MODULE';
delete from maxmenu         where keyvalue='APPNAME' and elementtype='APP';
delete from appdoctype      where app='APPNAME';
delete from sigoptflag      where app='APPNAME';
delete from query           where app='APPNAME';
delete from wfapptoolbar    where appname='APPNAME';
delete from ctrlcondprop    where ctrlconditionid in (select ctrlconditionid from ctrlcondition where ctrlgroupid in (select ctrlgroupid from ctrlgroup where app='APPNAME'));
delete from ctrlcondition   where ctrlgroupid in (select ctrlgroupid from ctrlgroup where app='APPNAME');
delete from ctrlgroup       where app='APPNAME';

Remember to commit the transaction.