SQL Language Elements.
SQL- Structured Query Language. SAP HANA DB is a relational database management system and it supports SQL & an extended version of SQL called SQL Scripts.
SQL is standardised, descriptive, optimised and is multi-set oriented (and not single record-based).
SQL language elements can be divided into three categories:
- DML = Data Manipulation Language
SELECT, INSERT, UPDATE, DELETE
- DDL = Data Definition Language
CREATE, ALTER, DROP, RENAME
- DCL = Data Control Language