You can delete a workspace interactively using the EKM Server Administration interface. Once the workspace has been deleted from the list of active workspaces in EKM, you can manually delete the files and database tables corresponding to the workspace.
The first step in deleting a workspace is to remove the reference to it in EKM.
Ensure all users have logged out of the workspace that you wish to delete.
Sign in to the EKM Administration Interface as superuser (see Signing In and Out of EKM Server Administration). Select a workspace and click . This opens the Delete Workspace dialog box.

Click to confirm that you want to delete the selected workspace.
When the operation is complete, the Delete Workspace Completed dialog box appears. Make note of the schema prefix which is required for deleting database tables. The schema prefix is also written to the log file. Click .

When you remove a workspace from EKM, various files and database tables associated with that workspace remain on the EKM server. The instructions below demonstrate the deletion of these remaining files for an EKM server that utilizes a MySQL database server. If you use a different database, the database commands for viewing and deleting tables will be different.
Stop the application server in which EKM is running. If EKM is installed in a clustered installation, stop the application server on each cluster node.
Delete the workspace from the database. To do this you
will need to remove all the tables corresponding to the workspace
from the EKM database. Assuming the name of database is ekm and the name of the workspace that you want to remove
is Temp, then the following sequence of commands
show how to remove the tables from a MySQL database.
Open the MySQL client console:
Switch to the EKM database by issuing the command:
use ekm;
List all the tables within this database by issuing the command:
show tables;
Delete all the tables whose prefix matches the schema prefix for the deleted workspace. When deleting a workspace using the EKM Server Administration interface, the schema prefix will be displayed and written to the log file.
The following series of commands will delete the tables that begin with the schema prefix "R2":
drop table r2_root_binval;drop table r2_root_bundle;drop table r2_root_names;drop table r2_root_refs; drop table r2_vn_binval;drop table r2_vn_bundle;drop table r2_vn_names;drop table r2_vn_refs;
When you restart the application server, the workspace will no longer be listed in any drop-down list in EKM.