CREATE TABLE Borrow
(
Bcard char(20) NOT NULL,
Bname nvarchar2(10) NULL,
Bclass nvarchar2(10) NULL,
Bdpt nvarchar2(10) NULL
CONSTRAINT PK_BCARD PRIMARY KEY (Bcard) VALIDATE;)CREATE TABLE Book
(
Book char(20) NOT NULL,
Bbname nvarchar2(10) NOT NULL,
Bauth nvarchar2(10) NULL,
Bprice nvarchar2(10) NULL,
Bnum float NULL,
CONSTRAINT PK_BBOOK PRIMARY KEY (Bbook) VALIDATE;
)CREATE TABLE Record
(
Rcard char(20) NOT NULL,
Rbook char(20) NOT NULL,
Rdate date NULL,
CONSTRAINT PK_RECORD PRIMARY KEY (Rcard,Rbook) VALIDATE,
CONSTRAINT FK_Bcard FOREIGN KEY (Bcard) REFERENCES Borrow(Bcard) VALIDATE,
CONSTRAINT FK_Bbook FOREIGN KEY (Bbook) REFERENCES Book(Bbook) VALIDATE;)这是个建3张表的脚本,但系统老是提示缺右括号,不能运行。不知道哪儿错了。望高手详解。
(
Bcard char(20) NOT NULL,
Bname nvarchar2(10) NULL,
Bclass nvarchar2(10) NULL,
Bdpt nvarchar2(10) NULL
CONSTRAINT PK_BCARD PRIMARY KEY (Bcard) VALIDATE;)CREATE TABLE Book
(
Book char(20) NOT NULL,
Bbname nvarchar2(10) NOT NULL,
Bauth nvarchar2(10) NULL,
Bprice nvarchar2(10) NULL,
Bnum float NULL,
CONSTRAINT PK_BBOOK PRIMARY KEY (Bbook) VALIDATE;
)CREATE TABLE Record
(
Rcard char(20) NOT NULL,
Rbook char(20) NOT NULL,
Rdate date NULL,
CONSTRAINT PK_RECORD PRIMARY KEY (Rcard,Rbook) VALIDATE,
CONSTRAINT FK_Bcard FOREIGN KEY (Bcard) REFERENCES Borrow(Bcard) VALIDATE,
CONSTRAINT FK_Bbook FOREIGN KEY (Bbook) REFERENCES Book(Bbook) VALIDATE;)这是个建3张表的脚本,但系统老是提示缺右括号,不能运行。不知道哪儿错了。望高手详解。
(
Bcard char(20) NOT NULL,
Bname nvarchar2(10) NULL,
Bclass nvarchar2(10) NULL,
Bdpt nvarchar2(10) NULL,
CONSTRAINT PK_BCARD PRIMARY KEY (Bcard) VALIDATE
); CREATE TABLE Book
(
Book char(20) NOT NULL,
Bbname nvarchar2(10) NOT NULL,
Bauth nvarchar2(10) NULL,
Bprice nvarchar2(10) NULL,
Bnum float NULL,
CONSTRAINT PK_BBOOK PRIMARY KEY (Bbook) VALIDATE
);
CREATE TABLE Record
(
Rcard char(20) NOT NULL,
Rbook char(20) NOT NULL,
Rdate date NULL,
CONSTRAINT PK_RECORD PRIMARY KEY (Rcard,Rbook) VALIDATE,
CONSTRAINT FK_Bcard FOREIGN KEY (Bcard) REFERENCES Borrow(Bcard) VALIDATE,
CONSTRAINT FK_Bbook FOREIGN KEY (Bbook) REFERENCES Book(Bbook) VALIDATE
);
(
Bcard char(20) NOT NULL,
Bname nvarchar2(10) NULL,
Bclass nvarchar2(10) NULL,
Bdpt nvarchar2(10) NULL
CONSTRAINT PK_BCARD PRIMARY KEY (Bcard) VALIDATE;);CREATE TABLE Book
(
Book char(20) NOT NULL,
Bbname nvarchar2(10) NOT NULL,
Bauth nvarchar2(10) NULL,
Bprice nvarchar2(10) NULL,
Bnum float NULL,
CONSTRAINT PK_BBOOK PRIMARY KEY (Bbook) VALIDATE;
);
CREATE TABLE Record
(
Rcard char(20) NOT NULL,
Rbook char(20) NOT NULL,
Rdate date NULL,
CONSTRAINT PK_RECORD PRIMARY KEY (Rcard,Rbook) VALIDATE,
CONSTRAINT FK_Bcard FOREIGN KEY (Bcard) REFERENCES Borrow(Bcard) VALIDATE,
CONSTRAINT FK_Bbook FOREIGN KEY (Bbook) REFERENCES Book(Bbook) VALIDATE;) ;
分号放错地方了
(
Bcard char(20) NOT NULL,
Bname nvarchar2(10) NULL,
Bclass nvarchar2(10) NULL,
Bdpt nvarchar2(10) NULL,
CONSTRAINT PK_BCARD PRIMARY KEY (Bcard) VALIDATE
)
;
CREATE TABLE Book
(
Bbook char(20) NOT NULL,
Bbname nvarchar2(10) NOT NULL,
Bauth nvarchar2(10) NULL,
Bprice nvarchar2(10) NULL,
Bnum float NULL,
CONSTRAINT PK_BBOOK PRIMARY KEY (Bbook) VALIDATE
)
;CREATE TABLE Record
(
Rcard char(20) NOT NULL,
Rbook char(20) NOT NULL,
Rdate date NULL,
CONSTRAINT PK_RECORD PRIMARY KEY (Rcard,Rbook) VALIDATE,
CONSTRAINT FK_Bcard FOREIGN KEY (Rcard) REFERENCES Borrow(Bcard) VALIDATE,
CONSTRAINT FK_Bbook FOREIGN KEY (Rbook) REFERENCES Book(Bbook) VALIDATE
)
;