use [ChangChengJunShiMoNi]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Jbsite_CollItem]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Jbsite_CollItem]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Jbsite_Collection]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Jbsite_Collection]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Jbsite_Comment]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Jbsite_Comment]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Jbsite_ContentTemplate]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Jbsite_ContentTemplate]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Jbsite_FriendLink]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Jbsite_FriendLink]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Jbsite_Master]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Jbsite_Master]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Jbsite_Photo]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Jbsite_Photo]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Jbsite_Placard]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Jbsite_Placard]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Jbsite_Soft]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Jbsite_Soft]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Jbsite_Source]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Jbsite_Source]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Jbsite_System]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Jbsite_System]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Jbsite_TempLabel]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Jbsite_TempLabel]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Jbsite_TempProject]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Jbsite_TempProject]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Jbsite_Template]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Jbsite_Template]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Jbsite_User]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Jbsite_User]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Jbsite_UserGroup]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Jbsite_UserGroup]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Jbsite_Vote]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Jbsite_Vote]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Jbsite_Article]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Jbsite_Article]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Jbsite_Channel]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Jbsite_Channel]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Jbsite_Class]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Jbsite_Class]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Jbsite_Special]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Jbsite_Special]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Jbsite_Tag]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Jbsite_Tag]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Jbsite_Thumb]') and OBJECTPROPERTY(id, N'IsUserTable') �