【SQL开源代码栏目提醒】:以下是网学会员为您推荐的SQL开源代码-classifieds-remove.sql,希望本篇文章对您学习有所帮助。
if exists (select * from dbo.sysobjects where id = object_id(N'[FK_Photos_Ads]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [classifieds_Photos] DROP CONSTRAINT FK_Photos_Ads
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[FK_SavedAds_Ads]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [classifieds_SavedAds] DROP CONSTRAINT FK_SavedAds_Ads
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[FK_Ads_Categories]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [classifieds_Ads] DROP CONSTRAINT FK_Ads_Categories
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[FK_Categories_Categories]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [classifieds_Categories] DROP CONSTRAINT FK_Categories_Categories
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[FK_Ads_Members]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [classifieds_Ads] DROP CONSTRAINT FK_Ads_Members
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[FK_SavedAds_Members]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [classifieds_SavedAds] DROP CONSTRAINT FK_SavedAds_Members
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[AdDeleted]') and OBJECTPROPERTY(id, N'IsTrigger') = 1)
drop trigger [AdDeleted]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[AdInserted]') and OBJECTPROPERTY(id, N'IsTrigger') = 1)
drop trigger [AdInserted]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[AdUpdated]') and OBJECTPROPERTY(id, N'IsTrigger') = 1)
drop trigger [AdUpdated]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[OnCategoryInsert]') and OBJECTPROPERTY(id, N'IsTrigger') = 1)
drop trigger [OnCategoryInsert]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[CountAdResponsesByStatus]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [CountAdResponsesByStatus]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[CountAdViewsByStatus]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [CountAdViewsByStatus]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[CountAdsByCategory]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [CountAdsByCategory]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[CountAdsByStatus]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [CountAdsByStatus]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[CountLocations]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [CountLocations]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[CountMembersByDateRange]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [CountMembersByDateRange]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[CountTopCategories]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [CountTopCategories]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[CreateCategory]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [CreateCategory]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[ExpireAd]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [ExpireAd]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[GetAdById]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [GetAdById]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[GetAdsByRandomOrder]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [GetAdsByRandomOrder]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[GetAdsByStatus]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [GetAdsByStatus]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[GetAllAdsByQuery]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [GetAllAdsByQuery]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[GetAllLocations]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [GetAllLocations]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[GetCategoriesByParentId]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
dro