- A+
所属分类:数据库技术
如果你打开查询,选择SQL视图,输入
CREATE TABLE stuTable(
sId CHAR(4) PRIMARY KEY,
sName CHAR(20) NOT NULL,
sCredit int,
sPd int,
constraint Ccredit_name CHECK(Ccredit>0),
constraint Period_name CHECK(sPd>0));
一定会提示check约束子句中错误,只能在ADO+mdb的编程运行环境中下通过下面的语句来实现
Dim Cnn As New ADODB.Connection
ff = "CREATE TABLE stuTable(
sId CHAR(4) PRIMARY KEY,
sName CHAR(20) NOT NULL,
sCredit int,
sPd int,
constraint Ccredit_name CHECK(Ccredit>0),
constraint Period_name CHECK(sPd>0))"
Cnn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\mydata.MDB;Persist Security Info=False"
Cnn.Execute (ff)