The following table shows the basic SQL statements and variations ADOCE supports.
Data Manipulation Language Statements |
Data Definition Language Statements |
| CREATE TABLE | ALTER TABLE to | add | drop | rename to | move to |
| DROP TABLE | INSERT INTO <table> (fields) VALUES (values) |
| CREATE INDEX | DELETE FROM <table> WHERE … |
| DROP INDEX | |
| SELECT * FROM <table> | |
| SELECT * FROM <table> WHERE <field expression list> | |
| SELECT * FROM <table> ORDER BY <indexed-field> | |
| SELECT * FROM <table> ORDER BY <non-indexed-field> | |
| SELECT * FROM <table> WHERE … ORDER BY <indexed> | |
| SELECT * FROM <table> WHERE … ORDER BY <non-indexed> | |
| SELECT <field list> FROM <table> [WHERE] [ORDER BY] | |
| SELECT <field list> FROM <table> [INNER JOIN <table2> ON <expression>] [WHERE] [ORDER BY] |
Although ADOCE 2.0 does not support Create/Drop Database syntax, the term Database is retained as a reserved word for compatibility with future versions.
Windows CE has some features that are not found in standard databases — for example, sorting null characters to the beginning or end of the table and supporting unsigned numeric data types. ADOCE SQL supports these features to the extent necessary to help migrate existing applications.
Note You can create tables and indexes using nonstandard sort orders and types; however, this is not recommended.