Cinchy Platform Documentation
Cinchy v5.6
Search
⌃K
Data Collaboration Overview
Release Notes
Release Notes
Getting Help
Cinchy Glossary
Frequently Asked Questions
Deployment Guide
Deployment Installation Guides
Upgrade Guides
Guides for Using Cinchy
User Guides
Builder Guides
Administrator Guide
Additional Guides
API Guide
API Overview
CQL
The Basics of CQL
CQL Examples
CQL Functions Master List
CQL Statements Overview
Cinchy DML Statements
Cinchy DDL Statements
Cinchy Supported Functions
Meta Forms
Introduction to Meta-Forms
Meta-Forms Deployment Installation Guide
Forms Data Types
Meta-Forms Builders Guides
Data Syncs
Getting Started with Data Syncs
Installation & Maintenance
Building Data Syncs
CLI Commands List
Error Logging
Supported Data Sync Sources
Supported Data Sync Destinations
Supported Real-Time Sync Stream Sources
Other Resources
Angular SDK
JavaScript SQK
Powered By
GitBook
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
Previous
CQL Functions Master List
Next
Cinchy DML Statements
Last modified
1mo ago