How to create and dropa SAP HANA tenant database

HANA-tenant-db.sql

-- source: https://blogs.sap.com/2016/10/27/create-tenant-database-sap-hana-express-sap-hana-academy/
-- create a tenant 
CREATE DATABASE TESTDB SYSTEM USER PASSWORD Initial1; 
-- add the script server service
ALTER DATABASE TESTDB ADD 'scriptserver'

-- or hit two birds with one stone 
CREATE DATABASE TESTDB ADD 'scriptserver' SYSTEM USER PASSWORD Initial1;

-- Tenants by default start automatically, but can be started and stopped manually as well
ALTER SYSTEM START DATABASE TESTDB;

-- Stop before you drop
ALTER SYSTEM STOP DATABASE TESTDB;
DROP DATABASE TESTDB;