DROP PROCEDURE [Mst_Sp_TeamMemberData]
GO
DROP PROCEDURE [Mst_Sp_Subscribe]
GO
DROP PROCEDURE [Mst_Sp_Service]
GO
DROP PROCEDURE [Mst_Sp_PhotoData]
GO
DROP PROCEDURE [Mst_Sp_PhotoCategory]
GO
DROP PROCEDURE [Mst_Sp_ContactUs]
GO
DROP PROCEDURE [Mst_Sp_Career]
GO
DROP PROCEDURE [Mst_Sp_BlogData]
GO
DROP PROCEDURE [Mst_Sp_BlogCategory]
GO
DROP PROCEDURE [Mst_Sp_AdminLogin]
GO
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[Mst_User]') AND type in (N'U'))
DROP TABLE [Mst_User]
GO
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[Mst_TeamMemberData]') AND type in (N'U'))
DROP TABLE [Mst_TeamMemberData]
GO
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[Mst_Subscribe]') AND type in (N'U'))
DROP TABLE [Mst_Subscribe]
GO
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[Mst_Service]') AND type in (N'U'))
DROP TABLE [Mst_Service]
GO
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[Mst_ContactUs]') AND type in (N'U'))
DROP TABLE [Mst_ContactUs]
GO
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[Mst_Career]') AND type in (N'U'))
DROP TABLE [Mst_Career]
GO
DROP VIEW [View_PhotoData]
GO
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[Mst_PhotoData]') AND type in (N'U'))
DROP TABLE [Mst_PhotoData]
GO
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[Mst_PhotoCategory]') AND type in (N'U'))
DROP TABLE [Mst_PhotoCategory]
GO
DROP VIEW [View_BlogData]
GO
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[Mst_BlogData]') AND type in (N'U'))
DROP TABLE [Mst_BlogData]
GO
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[Mst_BlogCategory]') AND type in (N'U'))
DROP TABLE [Mst_BlogCategory]
GO