The following SQL Reference is provided to you courtesy of Elevate Software, the manufacturer of DBISAM – the database engine used by Alventis. We are including the Reference almost verbatim, so don't be surprised to see numerous and as yet unfamiliar references to DBISAM. It is simply the engine ticking under the hood of Alventis. Note also that all references to "full text indexing" in the SQL Reference have nothing to do with the likewise-named feature of Alventis. Alventis does not use DBISAM's full text indexing (it uses a separate Rubicon engine to achieve a similar effect). We chose to include all information for the sake of completeness – even though you are likely to only ever need a small subset thereof.

 

DBISAM does not support the complete ANSI SQL-92 specification. Rather, it supports a subset of the specification that includes the most widely used SQL statements for data manipulation and definition, in some cases with DBISAM extensions, as well as some SQL statements that are specific to DBISAM:

 

SQL StatementStandard
SELECTSQL-92 with DBISAM Extensions
 
INSERTSQL-92 with DBISAM Extensions
 
UPDATESQL-92 with DBISAM Extensions
 
DELETESQL-92 with DBISAM Extensions
 
CREATE TABLESQL-92 with DBISAM Extensions
 
ALTER TABLESQL-92 with DBISAM Extensions
 
EMPTY TABLEDBISAM-specific
 
OPTIMIZE TABLEDBISAM-specific
 
EXPORT TABLEDBISAM-specific
 
IMPORT TABLEDBISAM-specific
 
REPAIR TABLEDBISAM-specific
 
UPGRADE TABLEDBISAM-specific
 
DROP TABLESQL-92 with DBISAM Extensions
 
RENAME TABLEDBISAM-specific
 
CREATE INDEXSQL-92 with DBISAM Extensions
 
DROP INDEXSQL-92 with DBISAM Extensions
 
START TRANSACTIONSQL-92 with DBISAM Extensions
 
COMMITSQL-92 with DBISAM Extensions
 
ROLLBACKSQL-92 with DBISAM Extensions