创建示例数据库代码.doc

本书所使用的示例数据库的代码 生成数据库结构的SQL 脚本如下： ======================================= /****** 对象: Table [dbo].[publisher] 脚本日期: 11/14/2009 13:34:32 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N[dbo].[publisher]) AND type in (NU)) DROP TABLE [dbo].[publisher] GO /****** 对象: Table [dbo].[user] 脚本日期: 11/14/2009 13:34:32 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N[dbo].[user]) AND type in (NU)) DROP TABLE [dbo].[user] GO /****** 对象: Table [dbo].[author] 脚本日期: 11/14/2009 13:34:32 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N[dbo].[author]) AND type in (NU)) DROP TABLE [dbo].[author] GO /****** 对象: Table [dbo].[book] 脚本日期: 11/14/2009 13:34:32 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N[dbo].[book]) AND type in (NU)) DROP TABLE [dbo].[book] GO /****** 对象: Table [dbo].[basket] 脚本日期: 11/14/2009 13:34:32 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N[dbo].[basket]) AND type in (NU)) DROP TABLE [dbo].[basket] GO /****** 对象: Table [dbo].[level] 脚本日期: 11/14/2009 13:34:32 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N[dbo].[level]) AND type in (NU)) DROP TABLE [dbo].[level] GO /****** 对象: Table [dbo].[item] 脚本日期: 11/14/2009 13:34:32 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N[dbo].[item]) AND type in (NU)) DROP TABLE [dbo].[item] GO /****** 对象: Table [dbo].[book_author] 脚本日期: 11/14/2009 13:34:32 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N[dbo].[book_author]) AND type in (NU)) DROP TABLE [dbo].[book_author] GO /****** 对象: Table [dbo].[book_author] 脚本日期: 11/14/2009 13:34:32 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N[dbo].[book_author]) AND type in (NU)) BEGIN CREATE TABLE [dbo].[book_author]( [ISBN] [nchar](15) COLLATE Chinese_PRC_CI