if exists(select * from sys.indexes i where i.[object_id] = OBJECT_ID('IES.T_MEDICAL_REQUEST_EXPERT', 'U') and i.name = 'UIX_T_MEDICAL_REQUEST_EXPERT_Request_F042Expert_Speciality')
	DROP INDEX UIX_T_MEDICAL_REQUEST_EXPERT_Request_F042Expert_Speciality on IES.T_MEDICAL_REQUEST_EXPERT
go

create unique index UIX_T_MEDICAL_REQUEST_EXPERT_Request_F042Expert_Speciality on IES.T_MEDICAL_REQUEST_EXPERT (MedicalRequest ASC, F042Trekmp ASC, ExpertSpeciality ASC)
go