Inicio

Table generator for YouAccess :

Returns an expression in Jet SQL which you can use to generate tables with YouAccess:

Table name:
Field definition:
SQL for YouAccess:

SQL reference (external):

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.

© 2012 - 2017 Ignacio Javier "igjav". Not enough?, you might try Cooled Universal Table Editor.