SAP HANA SQL
SQL Stands for Structured Query Language.
It is a Standard Language for communicating with Relational database like Oracle, MySQL etc. SQL is used to store, retrieve and modify the data in the database.
By Help of SQL in SAP HANA, we can do following job
- Create Schema.
- DDL(DATA DEFINATION LANGUAGE) Statement ( CREATE , ALTER , DROP ).
- DML(DATA MANIPULATION LANGUAGE) Statement (SELECT, UPDATE, INSERT).
- DCL(DATA CONTROL LANGUAGE) Statement ( GRANT ,REVOKE).
- Session Management.
- System Management.
- Transaction Management.