sql第九章 实践练习.docVIP

上机指导 执行脚本 1.创建主键约束 步骤3 步骤4 2.创建外键约束 步骤3 步骤4 步骤5 步骤6 步骤7 实践练习 执行脚本 步骤1 USE TeachingDB GO CREATE TABLE Departments (dptCode nchar(4) CONSTRAINT PK_Departments_dptCode PRIMARY KEY, dptName nvarchar(50) NOT NULL ) 步骤2 步骤3 USE TeachingDB GO ALTER TABLE Departments ADD CONSTRAINT UN_Departments_dptName UNIQUE(dptName) GO 步骤4 USE TeachingDB GO ALTER TABLE Studying ADD CONSTRAINT CK_Studying_mark CHECK (mark=0 and mark=100) GO 步骤5 步骤6 USE TeachingDB GO ALTER TABLE Studying ADD CONSTRAINT FK_Studying_stdID FOREIGN KEY(stdID) REFERENCES Students (stdID) GO 步骤7 步骤8 USE TeachingDB GO CREATE DEFAULT gen AS 男 GO 步骤9 USE TeachingDB GO CREATE RULE RL_classcode AS (@classcode like [A-Z][0-9][0-9][0-9]) GO CREATE TABLE Classes (classCode nchar(4) PRIMARY KEY, className nvarchar(50) NOT NULL, dptCode nchar(4) NOT NULL ) GO sp_bindrule RL_classcode,Classes.classCode GO 步骤10 删除规则 删除默认值 删除约束