Log onto a database in a single-container system:
hdbsql -n -i -u - p
Log onto a database in a multitenant database container:
hdbsql -n -i -u - p -d
-- 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;
-- Tenant DB List
select * from "SYS"."M_DATABASES"
-- Stop before you drop
ALTER SYSTEM STOP DATABASE TESTDB;
-- Drop tenant db
DROP DATABASE TESTDB;