diagram2.sql

来自「机械工业出版社《SQL Server应用开发实例教程》源代码」· SQL 代码 · 共 76 行

/*
   2001年4月10日 11:41:04
   User: 
   Server: JERRY
   Database: teaching_ Database
   Application: MS SQLEM - Data Tools
*/

BEGIN TRANSACTION
SET QUOTED_IDENTIFIER ON
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
SET ARITHABORT ON
SET NUMERIC_ROUNDABORT OFF
SET CONCAT_NULL_YIELDS_NULL ON
SET ANSI_NULLS ON
SET ANSI_PADDING ON
SET ANSI_WARNINGS ON
COMMIT
BEGIN TRANSACTION
ALTER TABLE dbo.Grade
	DROP CONSTRAINT FK_Grade_student
GO
ALTER TABLE dbo.student
	DROP CONSTRAINT PK_student
GO
ALTER TABLE dbo.student ADD CONSTRAINT
	PK_student PRIMARY KEY CLUSTERED 
	(
	student_no
	) ON [PRIMARY]

GO
COMMIT
BEGIN TRANSACTION
ALTER TABLE dbo.course_teaching
	DROP CONSTRAINT FK_course_teaching_course
GO
ALTER TABLE dbo.Grade
	DROP CONSTRAINT FK_Grade_course
GO
COMMIT
BEGIN TRANSACTION
ALTER TABLE dbo.Grade
	DROP CONSTRAINT FK_Grade_course_teaching
GO
ALTER TABLE dbo.course_teaching ADD CONSTRAINT
	FK_course_teaching_course1 FOREIGN KEY
	(
	course_no
	) REFERENCES dbo.course
	(
	course_no
	)
GO
COMMIT
BEGIN TRANSACTION
ALTER TABLE dbo.Grade ADD CONSTRAINT
	FK_Grade_student1 FOREIGN KEY
	(
	student_no
	) REFERENCES dbo.student
	(
	student_no
	)
GO
ALTER TABLE dbo.Grade ADD CONSTRAINT
	FK_Grade_course1 FOREIGN KEY
	(
	course_no
	) REFERENCES dbo.course
	(
	course_no
	)
GO
COMMIT