NET syntax for dynamically creating ACCESS data tables

Type name	TYPE	Remarks
Automatic ID	Integer	+ Identity (1, 1)
Text	Varchar (50)	The number in the brackets is the text length.
Long Integer	Integer
Integer	Short
Double Precision type	Double, float
Single precision type	Real
Byte type	Byte
Decimal	NUMERIC (6, 2)
Currency	Money
Remarks	Text
Date/time	Date, time, datetime
Yes/No	Bit
OLE object	OLEObject

Primary key
Required. not null.
Default Value: default date ()
-----------------------------------------------------------------------------

Example
Description of Table Name field name type affiliated attributes
--------------------------------------------------------------------------------
Create table mytable (m_id integer identity () primary key, -- auto-incrementing type, primary key
M_class varchar (50) not null default 'aaa', -- text, non-null, default value 'aaa'
M_int integer not null, -- long integer, non-null
M_numeric NUMERIC (6, 2), -- decimal type
M_money money not null default 0.00, -- currency type, non-empty, default 0.00
M_memo text, -- Remark type
M_date date default date (), -- date type, default: current date
M_boolean bit default yes, -- Boolean, yes by default
M_blob oleobject, -- blob type
M_double double, -- Double Type
M_float real) -- single precision type
Bytes ----------------------------------------------------------------------------------------------------------------------------