SQL Reference

Data types

• SQL Data Types

Comments

• SQL Comments

Data Definition

• Create Database
• Drop Database
• Create Cluster
• Alter Cluster
• Create Table
• Drop Table
• Alter Table
• Create Procedure
• Drop Procedure

Data Manipulation

• Select
• Insert
• Update
• Delete
• Truncate
• Use
• Backup
• Restore
• Rebuild
• Execute
• Generate Statistics
• User Procedures

Transactions

• Transactions

Control Flow Operators

• Case
• If Else
• While
• Raise Exception

SQL Functions and Operators

• Grouping Functions
• Date Functions
• String Functions
• Mathematical Operators / Functions / Arithmetic Functions / Bitwise functions
• Comparison operators
• Scope Functions
• Other Functions