SQL语句创建access表

CREATE TABLE Persons
(
ID AutoIncrement primary key,
Id_P int NOT NULL,
LastName varchar(255) NOT NULL,
sVarchar Varchar(255),
sText Text,
sMemo Memo,
sByte Byte,
sInteger Integer,
sLong Long,
sSingle Single,
sDouble Double,
sCurrency Currency,
sDate Date,
sTime Time,
sYes bit,
sOleObject OLEObject
)

SQL语句创建access表

标签：