Removing a service from a tenant database in SAP HANA

Yes, it is possible to remove a server component, which are no longer required. This can be performed using ALTER DATABASE SQL command.

Following perquisites should be met to perform this task −

• You are logged on to the system database.
• You have the system privilege DATABASE ADMIN.

To remove a service, you need to open SQL console of the SAP HANA studio and run “ALTER DATABASE” statement.

ALTER DATABASE DB1 REMOVE '<service name>' AT LOCATION 'HOST_A:30XXX'