h

来源:互联网 发布:调查人力资源矩阵图 编辑:程序博客网 时间:2024/03/29 16:27
USE masterGOCREATE DATABASE student_MisON(NAME =student_Data,FILENAME='D:\新建文件夹\[2012-05-21]loadrunner破解文件\student_Mis_data.mdf',SIZE=10,MAXSIZE=50,FILEGROWTH=5)LOG ON(NAME='student_Log',FILENAME='D:\新建文件夹\[2012-05-21]loadrunner破解文件\student_Mis_log.ldf',SIZE=5MB,MAXSIZE=25MB,FILEGROWTH=5MB)GOCREATE TABLE Depts(Dno CHAR(5)PRIMARY KEY,Dname CHAR(20)NOT NULL)CREATE TABLE Students(Sno CHAR(5) PRIMARY KEY,Sname CHAR(20)NOT NULL,Ssex CHAR(2),Sage INT,Dno CHAR(5),CONSTRAINT FK_Nno FOREIGN KEY(Dno)REFERENCES Depts)CREATE TABLE Courses(Cno CHAR(6)PRIMARY KEY,Cname CHAR(20),Pre_Cno CHAR(6),Credits INT)CREATE TABLE Reports(Sno CHAR(5),Cno CHAR(6),Grade INT CHECK(Grade>=0 AND Grade<=100),PRIMARY KEY(Sno,Cno),CONSTRAINT Student_Report FOREIGN KEY(Sno) REFERENCES Students,CONSTRAINT Report_Courses FOREIGN KEY(Cno) REFERENCES Courses)INSERTINTO DeptsVALUES('D01','自动化')INSERTINTO StudentsVALUES('S01','王建平','男',21,'D01')CREATE TABLE Student1(Sno1 CHAR(5)PRIMARY KEY,Sname1 CHAR(20)NOT NULL,Ssex1 CHAR(2),Sage1 INT,Dno1 CHAR(5),CONSTRAINT un_Sname1 UNIQUE(Sname1))ALTER TABLE Students1 ADD Sentrancedate1 DATETIMEALTER TABLE Students1 ALTER COLUMN Sage1 SMALLINTALTER TABLE Students1 DROP CONSTRAINT  un_Sname1ALTER TABLE Students1 DROP COLUMN Sage1CREATE UNIQUE INDEX Stu_Dno ON Stundents(Dno)CREATE UNIQUE INDEX Cou_Cridits ON Courses(Cridits)CREATE UNIQUE INDEX Rep_SCno ON Reports(Sno ASC ,Cno DESC)CREATE UNIQUE INDEX Dep_Dname ON Depts(Dname)SELECT *FROM Students


 

0 0
原创粉丝点击