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 port existing desktop computer ADO applications to the Windows CE platform.
You can create tables and indexes using nonstandard sort orders and types; however, this is not recommended.
The following table shows the basic SQL statements and variations ADOCE supports.
| Data Manipulation Language Statements | Data Definition Language Statements |
| Variations on the SELECT statement: | ALTER TABLE |
| SELECT - Join | CREATE DATABASE |
| SELECT - Like | CREATE INDEX |
| SELECT - Order By | CREATE TABLE |
| SELECT - Projection | DROP DATABASE |
| SELECT - Restricted | DROP INDEX |
| SELECT - Simple | DROP TABLE |