---
title: "Removing a tenant or vertical"
canonical: "https://onesaitplatform.refined.site/space/DOCT/3622993921/Removing%20a%20tenant%20or%20vertical"
format: markdown
---
Removing a tenant or vertical is possible but it is a manual process that requires the following steps.

You will have to access the platform configuration database (config db), and execute the following instructions:


```
use onesaitplatform_config_master;
#DELETE TENANT
delete from master_user where tenant_id in (select tenant.id from tenant where tenant.name="NOMBRE_TENANT");
delete from master_user_token where tenant_id in (select tenant.id from tenant where tenant.name="NOMBRE_TENANT");
delete from vertical_tenant where tenant_id in (select tenant.id from tenant where tenant.name="NOMBRE_TENANT");
delete from master_device_token where tenant="NOMBRE_TENANT";
delete from tenant where tenant.name="NOMBRE_TENANT";

#DELETE VERTICAL

delete from master_user where tenant_id in (select tenant_id from vertical_tenant inner join vertical on vertical.id=vertical_id where vertical.name="NOMBRE_VERTICAL");
delete from master_user_token where tenant_id in (select tenant_id from vertical_tenant inner join vertical on vertical.id=vertical_id where vertical.name="NOMBRE_VERTICAL");
delete from vertical_tenant where vertical_id in (select vertical.id from vertical where vertical.name="NOMBRE_VERTICAL");
delete from master_device_token where vertical="NOMBRE_VERTICAL";
drop schema onesaitplatform_config_NOMBRE_VERTICAL;
```


Finally we must do the following:

1. Stop cacheservice.
2. Stop controlpanelservice,
3. Start cacheservice and controlpanelservice.