IF EXISTS(SELECT 1 FROM sys.procedures WHERE name = 'AddTaminPrescription')
DROP PROCEDURE [dbo].[AddTaminPrescription];



IF exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TI_HamrahDrug]') and OBJECTPROPERTY(id, N'IsTrigger') = 1)
Drop Trigger [dbo].[TI_HamrahDrug]


IF EXISTS(SELECT * FROM sys.procedures WHERE name = 'Add_One_Kala_Drug')
DROP PROCEDURE [dbo].[Add_One_Kala_Drug];

IF EXISTS(SELECT * FROM sys.procedures WHERE name = 'Delete_Mandeh_Data')
DROP PROCEDURE [dbo].[Delete_Mandeh_Data];
