CQL Statements Overview

1. Overview

The Cinchy Query Language (CQL) statements are grouped into two (2) categories:

• Data Manipulation Language (DML) - DML is used to add, retrieve, update and manipulate data. For example, insert, update, delete.

• Data Definition Language (DDL) - DDL is used to create a database schema and define constraints. For example, create a table and alter a table.

2. Data Manipulation Language (DML)

List of available DML statements:

• ​SELECT​

• ​INSERT​

• ​UPDATE​

• ​DELETE​

• ​IF​

• ​Declare Variables​

• ​Set Variables​

3. Data Definition Languages (DDL)

List of available DDL statements:

• ​Create Table​
• ​Alter Table​
• ​Drop Table​
• ​Create View​
• ​Alter View​
• ​Drop View​
• ​Create Index​
• ​Drop Index​