Icon Overview

Introduction
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
VERIFY 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
Image