CQL Statements 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. 
Data Manipulation Language (DML)
List of available DML statements:
​SELECT​
​INSERT​
​UPDATE​
​DELETE​
​IF​
​Declare Variables​
​Set Variables​
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​

CQL Functions Master List

Cinchy DML Statements

Last modified 6mo ago