SQL Language SQL Standards Support Definition Statements (DDL and others) Data Manipulation Statements (DML) Data Query Statements (DQL) Calling User Defined Procedures and Functions Setting Properties for the Database and the Session General Operations on Database Transaction Statements Comments in Statements Statements in SQL Routines SQL Data and Tables Case Sensitivity Persistent Tables Temporary Tables Short Guide to Data Types Data Types and Operations Numeric Types Boolean Type Character String Types Binary String Types Bit String Types Lob Data Storage and Handling of Java Objects Type Length, Precision and Scale Datetime types Interval Types Arrays Array Definition Array Reference Array Operations 3. Running and Using HyperSQL Introduction The HSQLDB Jar Running Database Access Tools A HyperSQL Database In-Process Access to Database Catalogs Server Modes HyperSQL HSQL Server HyperSQL HTTP Server HyperSQL HTTP Servlet Connecting to a Database Server Security Considerations Using Multiple Databases Accessing the Data Closing the Database Creating a New Database 2. Table of Contents Preface Available formats for this document 1.