Warning, /libraries/kdb/docs/kdb_sql.txt is written in an unsupported language. File is not indexed.
0001 --------------------------------------------------------- 0002 KDb Common SQL definition 0003 Copyright (C) 2003 Jarosław Staniek staniek at kde.org 0004 Started: 2003-09-10 0005 --------------------------------------------------------- 0006 0007 0. Preface 0008 ---------- 0009 Below is definition (formal grammar and comments) for SQL used externally by KDb. 0010 "Externally" means that this language is visible to the user and can be used 0011 by her/him to define queries. 0012 0013 Many attempts has been done to create common part of many SQL versions that 0014 are currently in everyday use, mainly: 0015 - SQLite 0016 - MySQL 0017 - PostgreSQL 0018 0019 0020 1.1 CREATE TABLE 0021 ---------------- 0022 0023 <CREATE_TABLE> ::= CREATE TABLE <table_name> ( 0024 <field_def>[,<field_def>]* 0025 [,<table_constraint>]* 0026 ) 0027 <field_def> ::= <field_name> <field_type> <field_constraint> 0028 0029 Note 0030 ---- 0031 CREATE TABLE statement could be added to KDbSQL for advanced users convenience, 0032 although tables can be easier created with gui. CREATE TABLE for KDb has 0033 non-standard KDb-specific options. 0034 0035 TODO.......