一、默认值和级联更新删除关键字DEFAULT和ON
DEFAULT和ON是MS ACCESS SQL系统关键字,SQL语句中如果含有系统关键字,在ACCESS界面是无法执行的。如下SQL语句:
Create TABLE periodtbl
(
PDID AUTOINCREMENT,
PDname text(10) NOT NULL,
CONSTRAINT pk_periodtbl_PDID PRIMARY KEY (PDID),
CONSTRAINT UQ_periodtbl_PDname UNIQUE (PDname)
);
和
Create TABLE studenttbl
(
STUID AUTOINCREMENT,
STUname text(20) DEFAULT '请录入姓名',,
PDID INTEGER NOT NULL,
CONSTRAINT PK_studenttbl_STUID PRIMARY KEY (STUID),
CONSTRAINT FK_studenttbl_periodtbl_PDID FOREIGN KEY (PDID)
REFERENCES periodtbl(PDID)
ON Delete NO ACTION
ON Update CASCADE
);
执行进弹窗提示语法错误,如图:
但在VB.NET中却可以很好的执行:
Dim sqlstring As String = "Create TABLE studenttbl" & Environment.NewLine _