/****** Object:  Index [UIX_T_PATIENT_ADDRESS]    Script Date: 03.04.2026 15:11:52 ******/
DROP INDEX [UIX_T_PATIENT_ADDRESS] ON [AKUZ].[T_PATIENT_ADDRESS]
GO

exec dbo.sp_AlterDropColumn '[AKUZ].[T_PATIENT_ADDRESS]' , 'House', 1, 'varchar(10) NULL'
GO
/****** Object:  Index [UIX_T_PATIENT_ADDRESS]    Script Date: 03.04.2026 15:11:52 ******/
CREATE UNIQUE NONCLUSTERED INDEX [UIX_T_PATIENT_ADDRESS] ON [AKUZ].[T_PATIENT_ADDRESS]
(
	[City] ASC,
	[Street] ASC,
	[District] ASC,
	[PoliticalDistrict] ASC,
	[House] ASC,
	[Block] ASC,
	[Flat] ASC,
	[ZIPCode] ASC,
	[FreeAddressString] ASC,
	[Location] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO

