Deleting a user-created application in Maximo

You must use a database editor such as SQL Developer, DB Visualizer etc to delete the user created application.



Before you begin
You must shut down the application server. If you delete an application, it will not to remove  any custom tables, fields, or domains that you created to support the application.

Steps:

1. Log in to a database editor and connect to the database where the Maximo is running.
2. Enter the following commands, and replace the variable :appname 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 below sql queries.

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 (menutype='MODULE' and elementtype='APP' and keyvalue=:appname) 
    or (menutype !='MODULE' and moduleapp=:appname);
delete from appdoctype where app=:appname;
delete from sigoptflag where app=:appname;
commit;

3. Logout of the database editor and start the application server.