if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK__aspnet_Me__Appli__0EA330E9]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[aspnet_Membership] DROP CONSTRAINT FK__aspnet_Me__Appli__0EA330E9
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK__aspnet_Pa__Appli__403A8C7D]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[aspnet_Paths] DROP CONSTRAINT FK__aspnet_Pa__Appli__403A8C7D
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK__aspnet_Ro__Appli__2D27B809]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[aspnet_Roles] DROP CONSTRAINT FK__aspnet_Ro__Appli__2D27B809
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK__aspnet_Us__Appli__7E6CC920]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[aspnet_Users] DROP CONSTRAINT FK__aspnet_Us__Appli__7E6CC920
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK__aspnet_Pe__PathI__45F365D3]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[aspnet_PersonalizationAllUsers] DROP CONSTRAINT FK__aspnet_Pe__PathI__45F365D3
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK__aspnet_Pe__PathI__49C3F6B7]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[aspnet_PersonalizationPerUser] DROP CONSTRAINT FK__aspnet_Pe__PathI__49C3F6B7
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK__aspnet_Us__RoleI__31EC6D26]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[aspnet_UsersInRoles] DROP CONSTRAINT FK__aspnet_Us__RoleI__31EC6D26
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK__aspnet_Me__UserI__0F975522]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[aspnet_Membership] DROP CONSTRAINT FK__aspnet_Me__UserI__0F975522
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK__aspnet_Pe__UserI__4AB81AF0]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[aspnet_PersonalizationPerUser] DROP CONSTRAINT FK__aspnet_Pe__UserI__4AB81AF0
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK__aspnet_Pr__UserI__239E4DCF]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[aspnet_Profile] DROP CONSTRAINT FK__aspnet_Pr__UserI__239E4DCF
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK__aspnet_Us__UserI__30F848ED]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[aspnet_UsersInRoles] DROP CONSTRAINT FK__aspnet_Us__UserI__30F848ED
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[P_PostArticle]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[P_PostArticle]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[P_PostBlogComment]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[P_PostBlogComment]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[P_SearchBlogByTag]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[P_SearchBlogByTag]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[P_UpdateUserInfo]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[P_UpdateUserInfo]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[aspnet_AnyDataInTables]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[aspnet_AnyDataInTables]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[aspnet_Applications_CreateApplication]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[aspnet_Applications_CreateApplication]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[aspnet_CheckSchemaVersion]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[aspn�