Below exercise is to show you on how do we perform a schema creation in HANA database. We will show you the steps of schema deletion as well.
Create Schema
Step 1: Login to your HANA Studio and launch the SQL query page. Hit below command.
- SCHEMA-NAME = The schema name
- USER = Username (own the schema)
CREATE SCHEMA [SCHEMA-NAME] OWNED BY [USER];
Delete Schema
The simplest things to do in IT is always be the deletion but it is also the scariest things to do! 🙂
Step 1: Right click on the schema and select Delete.
Step 2: Select Cascade and this will delete all the objects and its dependent.
