SQL STATEMENTS IN SAP HANA

SAP HANA SQL statements are used to communicate with the SAP HANA database. These statements can be used for searching the database, create tables, add data to tables, or modify data, drop the table, set permissions for users and many more….

SAP HANA SQL statements are grouped into 10 main categories depending on their functionality:

1.    Data Definition Statements (DDS)

2.    Data Manipulation Statements (DMS)

3.    Procedural Statements (PS)

4.    Transaction Management Statements (TMS)

5.    Session Management Statements (SNMS) 

6.    Access Control Statements (ACS)

7.    Data Import Export Statements (DIES)

8.    System Management Statements (SMMS)

9.    Workload Management Statements (WMS)

10.  Tenant Database Management Statements (TDMS)

Data Definition Statements (DDS) category covers below the SQL operations.

·         ALTER FULLTEXT INDEX

·         ALTER INDEX

·         ALTER SEQUENCE

·         ALTER TABLE

·         ALTER VIRTUAL TABLE

·         COMMENT ON

·         CREATE FULLTEXT INDEX

·         CREATE INDEX

·         CREATE SCHEMA

·         CREATE SEQUENCE

·         CREATE STATISTICS

·         CREATE SYNONYM

·         CREATE TABLE

·         CREATE TRIGGER

·         CREATE VIEW

·         DROP INDEX

·         DROP SCHEMA

·         DROP SEQUENCE

·         DROP STATISTICS

·         DROP SYNONYM

·         DROP TABLE

·         DROP TRIGGER

·         DROP VIEW

·         REFRESH STATISTICS

·         RENAME COLUMN

·         RENAME INDEX

·         RENAME TABLE

Data Manipulation Statements (DMS) category covers below SQL operations that can be performed on SAP HANA database.

·         DELETE

·         EXPLAIN PLAN

·         INSERT

·         LOAD

·         MERGE DELTA

·         REPLACE | UPSERT

·         SELECT

·         TRUNCATE TABLE

·         UNLOAD

·         UPDATE

Procedural Statements (PS) category covers the below SQL operations that can be performed on SAP HANA Database.

·         ALTER PROCEDURE RECOMPILE

·         CALL

·         CREATE FUNCTION

·         CREATE PROCEDURE

·         CREATE TYPE

·         CREATE VIRTUAL FUNCTION

·         DO BEGIN…END

·         DROP FUNCTION

·         DROP PROCEDURE

·         DROP TYPE

Transaction Management Statements (TMS) category covers the below SQL operations that can be performed on SAP HANA Database.

·         COMMIT

·         LOCK TABLE

·         ROLLBACK

·         SET TRANSACTION

Session Management Statements (SNMS) category covers the below SQL operations that can be performed on SAP HANA Database.

·         CONNECT

·         SET HISTORY SESSION

·         SET SCHEMA

·         SET [SESSION]

·         UNSET [SESSION]

Access Control Statements (ACS) category covers the below SQL operations that can be performed on SAP HANA Database.

·         ALTER AUDIT POLICY

·         ALTER CREDENTIAL

·         ALTER REMOTE SOURCE

·         ALTER SAML PROVIDER

·         ALTER USER

·         CREATE AUDIT POLICY

·         CREATE CREDENTIAL

·         CREATE USER

·         CREATE REMOTE SOURCE

·         CREATE ROLE

·         CREATE SAML PROVIDER

·         DROP AUDIT POLICY

·         DROP CREDENTIAL

·         DROP REMOTE SOURCE

·         DROP ROLE

·         DROP SAML PROVIDER

·         DROP USER

·         GRANT

·         REVOKE

System Management Statements (SMMS): This category covers the below SQL operations that can be performed on SAP HANA Database.

·         ALTER SYSTEM ALTER CONFIGURATION

·         ALTER SYSTEM ALTER SESSION SET

·         ALTER SYSTEM ALTER SESSION UNSET

·         ALTER SYSTEM APPLICATION ENCRYPTION

·         ALTER SYSTEM ALTER TABLE PLACEMENT

·         ALTER SYSTEM CANCEL [WORK IN] SESSION

·         ALTER SYSTEM CLEAR AUDIT LOG

·         ALTER SYSTEM CLEAR SQL PLAN CACHE

·         ALTER SYSTEM CLEAR TRACES

·         ALTER SYSTEM DISABLE ALL ASYNCHRONOUS TABLE REPLICAS

·         ALTER SYSTEM DISCONNECT SESSION

·         ALTER SYSTEM ENABLE ALL ASYNCHRONOUS TABLE REPLICAS

·         ALTER SYSTEM LOAD PERFTRACE

·         ALTER SYSTEM LOGGING

·         ALTER SYSTEM PERSISTENCE ENCRYPTION

·         ALTER SYSTEM RECLAIM DATA SPACE

·         ALTER SYSTEM RECLAIM DATAVOLUME

·         ALTER SYSTEM RECLAIM LOG

·         ALTER SYSTEM RECLAIM VERSION SPACE

·         ALTER SYSTEM RECONFIGURE SERVICE

·         ALTER SYSTEM RECOMPILE SQL PLAN CACHE ENTRY

·         ALTER SYSTEM REMOVE TRACES

·         ALTER SYSTEM RESET MONITORING VIEW

·         ALTER SYSTEM SAVE PERFTRACE

·         ALTER SYSTEM SAVEPOINT

·         ALTER SYSTEM START PERFTRACE

·         ALTER SYSTEM STOP PERFTRACE

·         ALTER SYSTEM STOP SERVICE

·         CREATE CERTIFICATE

·         DROP CERTIFICATE

·         SET SYSTEM LICENSE

·         UNSET SYSTEM LICENSE ALL

·         ALTER PSE

·         CREATE PSE

·         DROP PSE

·         SET PSE

·         UNSET PSE

Data Import Export Statements (DIES): This category covers the below SQL operations that can be performed on SAP HANA Database.

·         EXPORT

·         IMPORT

·         IMPORT FROM

·         IMPORT SCAN

Tenant Database Management Statements (TDMS) category covers the below SQL operations that can be performed on SAP HANA Database.

·         CREATE DATABASE

·         DROP DATABASE

·         ALTER DATABASE

·         ALTER SYSTEM START DATABASE

·         ALTER SYSTEM STOP DATABASE

Workload Management Statements (WMS) category covers the below SQL operations that can be performed on SAP HANA Database.

·         CREATE WORKLOAD MAPPING

·         ALTER WORKLOAD MAPPING

·         DROP WORKLOAD MAPPING

·         CREATE WORKLOAD CLASS

·         ALTER WORKLOAD CLASS

·         DROP WORKLOAD CLASS