CQL Statements Overview

Overview

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

• **Data Manipulation Language - Use DML to add, retrieve, update and manipulate data. For example, insert, update, delete.
• **Data Definition Language - 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​