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 Statement

Standard

SELECT	SQL-92 with DBISAM Extensions
INSERT	SQL-92 with DBISAM Extensions
UPDATE	SQL-92 with DBISAM Extensions
DELETE	SQL-92 with DBISAM Extensions
CREATE TABLE	SQL-92 with DBISAM Extensions
ALTER TABLE	SQL-92 with DBISAM Extensions
EMPTY TABLE	DBISAM-specific
OPTIMIZE TABLE	DBISAM-specific
EXPORT TABLE	DBISAM-specific
IMPORT TABLE	DBISAM-specific
VERIFY TABLE	DBISAM-specific
REPAIR TABLE	DBISAM-specific
UPGRADE TABLE	DBISAM-specific
DROP TABLE	SQL-92 with DBISAM Extensions
RENAME TABLE	DBISAM-specific
CREATE INDEX	SQL-92 with DBISAM Extensions
DROP INDEX	SQL-92 with DBISAM Extensions
START TRANSACTION	SQL-92 with DBISAM Extensions
COMMIT	SQL-92 with DBISAM Extensions
ROLLBACK	SQL-92 with DBISAM Extensions

More Support Options

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Incident Reports

Roadmap