Table generator for YouAccess :
Returns an expression in Jet SQL which you can use to generate tables with YouAccess:
SQL reference (external):
- SELECT. Get a result set.
- INSERT. Add entries to a table.
- UPDATE. Update entries in a table.
- DELETE. Delete entries in a table.
- JOIN. Mix 2 or more tables in a result set.
- CREATE TABLE. Add a new table to the database.
- ALTER TABLE. Modify the definition of a table.
- Table INDEXes. Accelerate queries.
- DROP TABLE. Table deletion.
MS Access (Jet engine) data types, synonyms and ANSI SQL equivalents:
| Jet SQL | ANSI SQL | Synonym |
|---|---|---|
| BINARY | BIT, BIT VARYING | VARBINARY |
| BIT | Not supported | BOOLEAN, LOGICAL, LOGICAL1, YESNO |
| BYTE | Not supported | INTEGER1 |
| COUNTER | Not supported | AUTOINCREMENT |
| CURRENCY | Not supported | MONEY |
| DATETIME | DATE, TIME, TIMESTAMP | DATE, TIME, TIMESTAMP |
| GUID | Not supported | |
| SINGLE | REAL | FLOAT4, IEEESINGLE, REAL |
| DOUBLE | DOUBLE PRECISION, FLOAT | FLOAT, FLOAT8, IEEEDOUBLE, NUMBER, NUMERIC |
| SHORT | SMALLINT | INTEGER2, SMALLINT |
| LONG | INTEGER | INT, INTEGER, INTEGER4 |
| LONGBINARY | Not supported | GENERAL, OLEOBJECT |
| LONGTEXT | Not supported | LONGCHAR, MEMO, NOTE |
| TEXT | CHARACTER, CHARACTER VARYING | ALPHANUMERIC, CHAR, CHARACTER, STRING, VARCHAR |
| VALUE | Not supported |
ANSI SQL DECIMAL and INTERVAL are not supported in Jet SQL.