love你低调 love你低调
关注数: 0 粉丝数: 23 发帖数: 239 关注贴吧数: 11
小白,帮忙看看这个表建哪里去了?我怎么找不到,想删除啊。.. CREATE TABLE Student (SNO CHAR(4) NOT NULL PRIMARY KEY(SNO), SNAME VARCHAR(20), SEX CHAR(2) DEFAULT '男'CHECK(SEX='男' OR SEX='女'), AGE SMALLINT CHECK(AGE>=15 AND AGE<=45), CLASS CHAR(5)); go CREATE TABLE Course (CNO CHAR(4) NOT NULL PRIMARY KEY(CNO), CNAME VARCHAR(40), TNO CHAR(3)); go CREATE TABLE SC (SNO CHAR(4) NOT NULL CONSTRAINT C_F FOREIGN KEY REFERENCES Student(SNO), CNO CHAR(4) NOT NULL, GRADE SMALLINT CHECK ((GRADE IS NULL) OR (GRADE BETWEEN 0 AND 100)), PRIMARY KEY(SNO,CNO), FOREIGN KEY(CNO) REFERENCES Course(CNO)); go CREATE TABLE Teacher (TNO CHAR(3) NOT NULL PRIMARY KEY(TNO), TANME VARCHAR(20), SEX CHAR(2) DEFAULT '男'CHECK(SEX='男' OR SEX='女'), AGE SMALLINT CHECK(AGE>=18 AND AGE<=70), PROF VARCHAR(40), DEPT VARCHAR(40)); go INSERT INTO Student VALUES('9803','李华','男',19,'98030'); INSERT INTO Student VALUES('9804','张军','男',18,'98030'); INSERT INTO Student VALUES('9805','王红','女',19,'98031'); INSERT INTO Student VALUES('9806','黄华','女',17,'98032'); INSERT INTO Student VALUES('9807','大卫','男',16,'98033'); INSERT INTO Student VALUES('9808','赵峰','男',20,'98033'); INSERT INTO Student VALUES('9809','赵娟','女',21,'98033'); go INSERT INTO Course VALUES('8104','计算机导论','801'); INSERT INTO Course VALUES('8244','数据库系统','803'); INSERT INTO Course VALUES('8105','C语言','802'); INSERT INTO Course VALUES('8245','数据结构','804'); go INSERT INTO SC VALUES('9803','8104',67); INSERT INTO SC VALUES('9804','8244',96); INSERT INTO SC VALUES('9805','8104',86); INSERT INTO SC VALUES('9806','8244',76); INSERT INTO SC VALUES('9807','8104',45); INSERT INTO SC VALUES('9808','8244',76); INSERT INTO SC VALUES('9809','8104',87); INSERT INTO SC VALUES('9803','8105',86); INSERT INTO SC VALUES('9804','8245',76); INSERT INTO SC VALUES('9805','8105',56); INSERT INTO SC VALUES('9806','8245',96); INSERT INTO SC VALUES('9807','8105',85); INSERT INTO SC VALUES('9808','8245',79); INSERT INTO SC VALUES('9809','8105',95); go INSERT INTO Teacher VALUES('801','李新','男',38,'副教授','计算机系'); INSERT INTO Teacher VALUES('802','钱军','男',45,'教授','计算机系'); INSERT INTO Teacher VALUES('803','王立','女',35,'副教授','食品系'); INSERT INTO Teacher VALUES('804','李丹','女',22,'讲师','食品系'); go 我用是事sql sever
1 下一页