blob: 128bbae4b8fba7fd8c3f81376a55196a7ee84c53 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
|
---------------------------------------------------------
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> ::= CREATE TABLE <table_name> (
<field_def>[,<field_def>]*
[,<table_constraint>]*
)
<field_def> ::= <field_name> <field_type> <field_constraint>
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.......
|
