--------------------------------------------------------- KexiDB Common SQL definition Copyright (C) 2003 Jaroslaw Staniek js at iidea dot pl Started: 2003-09-10 Kexi home page: http://www.koffice.org/kexi/ --------------------------------------------------------- 0. Preface ---------- Below is definition (formal grammar and comments) for SQL used externally by KexiDB. "Externally" means that this language is visible to the user and can be used by her/him to define queries. Many attempts has been done to create common part of many SQL versions that are currently in everyday use, mainly: - SQLite - MySQL - PostgreSQL 1.1 CREATE TABLE ---------------- ::= CREATE TABLE ( [,]* [,]* ) ::= Note ---- CREATE TABLE statement could be added to KexiDBSQL for advanced users convenience, although tables can be easier created with gui. CREATE TABLE for KexiDB have non-standard options KexiDB-specific. TODO.......