SQL Reference Guide

This section provides a complete description of the Structured Query Language (SQL) used to manage information in SnappyData. It includes syntax, usage, keywords, and examples of the SQL statements used on SnappyData.

The following topics are covered in this section:

• ALTER TABLE

• CREATE STATEMENTS

  • CREATE DISKSTORE

  • CREATE EXTERNAL TABLE

  • CREATE FUNCTION

  • CREATE INDEX

  • CREATE SCHEMA

  • CREATE SAMPLE TABLE

  • CREATE STREAM TABLE

  • CREATE TABLE

  • CREATE TEMPORARY TABLE

  • CREATE VIEW

• DELETE

• DEPLOY STATEMENTS

  • DEPLOY PACKAGES

  • DEPLOY JARS

  • UNDEPLOY

• DROP STATEMENTS

  • DROP DISKSTORE

  • DROP FUNCTION

  • DROP INDEX

  • DROP TABLE/EXTERNAL TABLE/SAMPLE TABLE

  • DROP SCHEMA

• GRANT

• INSERT

• LATERAL VIEW

• PUT INTO

• REVOKE

• SELECT

• SET ISOLATION

• SET SCHEMA

• TRUNCATE TABLE

• UPDATE