The solidDB® SQL syntax is based on the ANSI X3H2-1989 (SQL-89) level 2 standard including important SQL-92 and SQL-99 extensions.
To execute SQL statements, you can use the solidDB® SQL Editor (solsql) or solidDB® SQL Remote Control (solcon), or various ODBC or JDBC compliant tools. Additionally, you can execute SQL statements from a file, for example, to automate tasks. You can also use such files for rerunning your SQL statements later or as a document of your users, tables, and indexes.
Remember: When using solsql, SQL statements must be terminated with a semicolon (;). Otherwise, terminating SQL statements with a semicolon leads to a syntax error.