Want to delete a particular Process Instance ??

We can't delete a particular instance from MWS(My WebMethods Server), so if we want to delete that process Instance we can still do it. Below are lines of scripts which are to be run for deleting an instance --

delete FROM wmprocess a where a.processkey like '%instanceid_to_delete%'
delete from wmprocessassoc a where a.instanceid = '%instanceid_to_delete%'
delete from wmprocessrecent a where a.instanceid = '%instanceid_to_delete%'
delete from wmprocessstep a where a.instanceid = '%instanceid_to_delete%'


wmprocess - contains all the process instance information. for each step, there will be start and complete entries available.

wmprocessrecent - holds recent process instance that are run. instanceid & processkey are available to delete

wmstepdefinition - contains details about each step in a process model

wmprocessassoc - Not very sure of this table what it has ? To my guess - it contains details of the associated processes. It comes into picture when there is an implementation of sub-process.
comments are most welcome to fill out this table information..