How to stop , Start and drop tenant Database in HANA database

1. open one putty session.
2. $ su  - <SID>adm
3. make sure that the present word directory ($ pwd) is /usr/sap/hana/HDB<XX>
4. issue the below command:

                               hdbsql -U system -p <password>  -n vh<xxx><xxx><db>:3<XX>13

       Note: issue the below OS command to make sure the sid

df -h in the DB host, which will give DB<sid>

df -h in the application host,which will give Application <sid>

   5. To check for list of tenant databases available:

                     select * from M_DATABASES
   6.To stop the tenant DB issue the below command:

                 alter system stop database <SID>                     Note: choose one <sid> from step 5 query


   7.To start the tenant DB issue the below command:

                                        alter system start database <sid>

   8. To delete the tenant database permanently along with data in it, issue the below command:
        Make sure of your Tenant DB sid, which executing the below command, As it will delete every thing.

                                  

                                                drop database <SID>