CQL statements overview

Overview

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

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

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

Data Manipulation Language (DML)

List of available DML statements:

• ​SELECT​

• ​INSERT​

• ​UPDATE​

• ​DELETE​

• ​IF​

• ​DECLARE​

• SET

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​