SQL reference (H2 mirror)
H2Sharp's own design over H2 content. Anchors are stable: #commands, #functions, #datatypes, #grammar, #systemtables — deep links survive a site move.
This is H2's full grammar, not the engine's capabilities. The pages below mirror what the port is written against; the engine executes a subset today (no
JOIN, subqueries, window functions or
MERGE yet). See
port status for what actually runs.
Verified against the project's own copy. The main repo commits the same 8 files in docs/ with a SHA-256 manifest, and its conformance suite cites line numbers in them — a drift would break tests. Our mirror is byte-identical, all 8 files; check with python tools/verify-snapshot.py.
Commands mirror
SELECT · INSERT · UPDATE · DELETE · MERGE · DDL · SET · SCRIPT…
Open →Data Types mirror
Types, domains, literals, CAST.
Open →Grammar mirror
Expressions, predicates, railroad diagrams.
Open →System Tables mirror
INFORMATION_SCHEMA, system views.
Open →Cheat Sheet mirror
H2's one-page summary — a link list rather than a specification, so no conformance test cites it.
Open →
H2Sharp in progress