实训7 数据完整性操作.xlsVIP

Sheet3 Sheet2 Sheet1 目的和要求 实验环境 实验原理 实验内容与步骤 use xk go alter table department add constraint pk_department primary key (departNO) alter table course add constraint pk_course primary key (couNO) alter table class add constraint pk_class primary key (classNO) 以下为：在创建表的同时创建主键约束。 create table department (departno nvarchar(2) not null, departname nvarchar(20) not null, constraint PK_department primary key (departNO) ) 任务5 使用transact-sql语句删除department表名字为PK_Department的主键约束。 drop constraint pk_department USE Xk GO ALTER TABLE StuCou ADD CONSTRAINT StuNo_FK FOREIGN KEY (StuNo) REFERENCES Student (StuN