Quadcap Embeddable Database

• QED Home
• User's Guide
• Developer's Guide
• API Documentation
• SQL Reference
• FAQ
• Changes

Quadcap Software

• Home
• Download
• Products
• Services
• Purchase
• Support
• About

This document contains an annotated version of the QED SQL grammar. This is the actual ANTLR grammar used by the QED parser, and is therefore not necessarily optimized for reference purposes, but does serve to express exactly the SQL language implemented by QED.

• Index of Statements
• Index of Types
• Index of Functions

Statements

• ALTER TABLE
• COMMIT
• CREATE INDEX
• CREATE SCHEMA
• CREATE TABLE
• CREATE VIEW
• DELETE
• DROP TABLE, DROP VIEW
• GRANT
• INSERT
• ROLLBACK
• SELECT
• UPDATE

Types

• BIGINT
• BIT, BINARY
• BIT VARYING, VARBINARY
• BLOB, BINARY LARGE OBJECT
• BOOLEAN
• CHAR, CHARACTER
• CLOB, CHARACTER LARGE OBJECT
• DATE
• DEC, DECIMAL, NUMERIC
• DOUBLE PRECISION
• FLOAT
• INT, INTEGER
• INTERVAL
• REAL
• SMALLINT
• TIME
• TIMESTAMP
• VARCHAR

Functions

• ABS
• ASCII
• ACOS
• ASIN
• ATAN
• ATAN2
• BIT_LENGTH
• CASE
• CAST
• CEILING
• CHAR
• CHAR_LENGTH
• CHARACTER_LENGTH
• COALESCE
• COS
• COT
• CONCAT
• CURDATE
• CURTIME
• DATABASE
• DAYNAME
• DAYOFMONTH
• DAYOFWEEK
• DAYOFYEAR
• DEGREES
• DIFFERENCE
• EXP
• FLOOR
• HOUR
• IFNULL
• INSERT
• LEFT
• LENGTH
• LOCATE
• LOG
• LOG10
• LOWER
• LCASE
• LTRIM
• MINUTE
• MOD
• MONTH
• MONTHNAME
• NOW
• NULLIF
• OCTET_LENGTH
• PI
• POWER
• QUARTER
• RADIANS
• RAND
• REPEAT
• REPLACE
• RIGHT
• ROUND
• RTRIM
• SECOND
• SIGN
• SIN
• SOUNDEX
• SPACE
• SQRT
• SUBSTRING
• TAN
• TIMESTAMPADD
• TIMESTAMPDIFF
• TRUNCATE
• UPPER
• UCASE
• USER
• WEEK
• YEAR
• DIGEST
• LAST_INSERT_ID