SQL Basics Part1

hana sql neww  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:

  1. DML = Data Manipulation Language
                 SELECT, INSERT, UPDATE, DELETE
  2. DDL = Data Definition Language
                 CREATE, ALTER, DROP, RENAME
  3. DCL = Data Control Language
                 GRANT, REVOKE

 

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s