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​​

CQL Functions Master List

Cinchy DML Statements

Last modified 1mo ago