怎么也运行不了。。。
CreateTable Doctor (
name varchar(255)NOT NULL,
pagerNumb int,
doctorID INT,
CONSTRAINT DR primary key(DOCTORID) );
CreateTable Pat_Doc_Treat (
dates int,
comments varchar(255),
constraint Ti primary key(dates),
constraint pdt foreign key (dr) references doctor (dr) );
我是跟着这个格式打的... 求大神们帮帮我这个菜鸟。。
CREATE TABLE qcc17(
SID int ,
NAME Varchar(255)NOT NULL,
AGE INT,
CONSTRAINT FK_STUDENT PRIMARY KEY (sid)
);
cREATE TABLE deptQCC(
DEPTNAME Varchar(255)NOT NULL,
SID INT,
PRIMARY KEY (DEPTNAME),
CONSTRAINT FK_STUDENTS FOREIGN KEY (SID )
REFERENCES QCC17(SID )
);