shaolin.master.dp2

来自「1:首先要导入hotel数据」· DP2 代码 · 共 21 行

/****** Object:  Table [dbo].[book]    Script Date: 2007-7-4 21:52:28 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[book]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[book]
GO

/****** Object:  Table [dbo].[book1]    Script Date: 2007-7-4 21:52:28 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[book1]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[book1]
GO

/****** Object:  Table [dbo].[borrow]    Script Date: 2007-7-4 21:52:28 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[borrow]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[borrow]
GO

/****** Object:  Table [dbo].[reader]    Script Date: 2007-7-4 21:52:28 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[reader]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[reader]
GO