diagram1.sql

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

/*
   2001年4月9日 12:32:31
   User: 
   Server: JERRY
   Database: diskrent
   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
COMMIT
BEGIN TRANSACTION
ALTER TABLE dbo.gpb ADD CONSTRAINT
	FK_gpb_ghsb FOREIGN KEY
	(
	ghsbh
	) REFERENCES dbo.ghsb
	(
	ghsbh
	)
GO
COMMIT
BEGIN TRANSACTION
COMMIT
BEGIN TRANSACTION
ALTER TABLE dbo.gpczb ADD CONSTRAINT
	FK_gpczb_employee FOREIGN KEY
	(
	ygbh
	) REFERENCES dbo.employee
	(
	ygbh
	)
GO
ALTER TABLE dbo.gpczb ADD CONSTRAINT
	FK_gpczb_gpb FOREIGN KEY
	(
	gph
	) REFERENCES dbo.gpb
	(
	gph
	)
GO
COMMIT