Valentina SQL Reference

A reference of Valentina SQL, an implementation of SQL 1992-2003 with extensions in the Valentina engine.

• Description of Valentina SQL Grammar Rules
• LEXICAL TOKENS
• KEYWORDS

• Useful SQL Standard Grammars
  • sql_1992 / sql_1999 / sql_2003 / sql_2008 / sql_2011

• CREATE INDEX statement
• CREATE KEYVALUE statement - NEW in 7.0
• CREATE LINK statement
• CREATE SEQUENCE statement - NEW in 5.0
• CREATE TABLE statement
• CREATE TRIGGER statement - NEW in 3.0
• CREATE TYPE statement - NEW in 5.0
• CREATE VIEW statement - NEW in 3.0

• ALTER LINK statement - NEW in 5.0
• ALTER TABLE statement
• ALTER TRIGGER statement - NEW in 3.0
• ALTER Type statement NEW in 5.0
• ALTER VIEW statement - NEW in 4.3

• DROP INDEX statement
• DROP KEYVALUE statement - NEW in 7.0
• DROP LINK statement
• DROP SEQUENCE statement - NEW in 5.0
• DROP TABLE statement
• DROP TRIGGER statement - NEW in 3.0
• DROP Type statement - NEW in 5.0
• DROP VIEW statement - NEW in 3.0

• CREATE PROCEDURE/FUNCTION Statement - NEW in 3.0
• DROP PROCEDURE/FUNCTION Statement - NEW in 3.0

• Valentina Compound Statement Syntax
  • BEGIN ... END Compound statement Syntax
  • DECLARE Statement Syntax
  • Variables in Stored Routines
  • Cursors
  • Error Handling - NEW in 3.0
  • Flow Control Constructs - NEW in 3.0
  • Loops - NEW in 3.0
  • Return Statement - NEW in 3.0

• CALL Statement - NEW in 3.0
• EXECUTE Statement - NEW in 3.0

• INSERT statement
  
• UPDATE statement
  
• DELETE statement
  
• TRUNCATE statement
  

• LINK/UNLINK statements
• MERGE statements

• KEYVALUE DELETE statement
  
• KEYVALUE GET statement
  
• KEYVALUE INSERT statement
  
• KEYVALUE UPDATE statement
  
• KEYVALUE UPSERT statement
  

• Expression statement
  
  • Operators
  • Operator ->
  • Functions Description
    • Bitwise Functions
    • Comparison Functions
    • Collection Functions
    • Date Time Functions
    • Flow Control Functions
    • LastRecID Functions
    • Link Functions
    • Lists Functions
    • Logical Functions
    • Numeric Functions
    • String Functions
    • Trigonometry Functions
    • User Functions
    • Window Functions

• SELECT statement
  • CASЕ
  • JOIN
  • Subqueries and Compound Queries
  • UNION, INTERSECT and EXCEPT

• SELECT FOR JSON – NEW in v5.5
• SELECT FOR REPORT – NEW in v4.0
• SELECT FOR XML – NEW in v4.0

• PIVOT TABLE

• HIERARCHICAL (RECURSIVE) QUERIES

• CREATE DATABASE statement - NEW in 3.0
  
• DROP DATABASE statement - NEW in 3.0
  
• SHOW DATABASES - NEW in 3.0
  
• USE DATABASE statement - NEW in 3.0
  

• COPY LINKS statement

• Overview
  • GET/SET PROPERTY statement
    
  • SHOW PROPERTIES

• SHOW statements
  • SHOW CHECKS - NEW in 5.0
  • SHOW CONNECTIONS - NEW in 5.0
  • SHOW CONSTRAINTS - NEW in 5.0
  • SHOW COLUMNS
  • SHOW DATABASES
  • SHOW EVENTS - NEW in 3.0
  • SHOW INDEXES - NEW in 5.0
  • SHOW LINKS - NEW in 3.3
  • SHOW LOG - NEW in 5.0
  • SHOW LOGS - NEW in 5.0
  • SHOW PROCEDURES - NEW in 3.3
  • SHOW PROJECTS
  • SHOW PROPERTIES
  • SHOW STATUS - NEW in 3.3
  • SHOW SEQUENCES - NEW in 5.0
  • SHOW TABLES
  • SHOW TRIGGERS - NEW in 3.0
  • SHOW USERS - NEW in 3.0
  • SHOW VARIABLES - NEW in 4.6

• BACKUP DATABASE statement - NEW in 3.0
• CLONE DATABASE statement
• COMPACT statement
• DEFRAGMENT statement
• DIAGNOSE statement
• MAIL statement - NEW in 5.0
• PRINT statement
• REINDEX statement
• REPORT statement - NEW in 6.2

• REGISTER DATABASE Statement - NEW in 4.0
• UNREGISTER DATABASE Statement - NEW in 4.0
• REGISTER PROJECT Statement - NEW in 4.0
• UNREGISTER PROJECT Statement - NEW in 4.0

• DROP CONNECTIONS Statement - NEW in 4.0

• CREATE USER Statement - NEW in 4.0
• DROP USER Statement - NEW in 4.0

• GRANT PRIVILEGES Statement - NEW in 4.0
• REVOKE PRIVILEGES Statement - NEW in 4.0

• SET PASSWORD Statement - NEW in 9.0

• CREATE EVENT Statement - NEW in 3.0
• DROP EVENT Statement - NEW in 3.0
• ALTER EVENT Statement - NEW in 3.0