if exists (select * from dbo.sysindexes where name = N'eap_VoucherControls_VoucherID' and id = object_id(N'[dbo].[eap_VoucherControls]'))
drop index [dbo].[eap_VoucherControls].[eap_VoucherControls_VoucherID]
CREATE NONCLUSTERED INDEX [eap_VoucherControls_VoucherID] ON [dbo].[eap_VoucherControls] ([VoucherID] ASC )
if exists (select * from dbo.sysindexes where name = N'eap_VoucherTableColumn_TableID' and id = object_id(N'[dbo].[eap_VoucherTableColumn]'))
drop index [dbo].[eap_VoucherTableColumn].[eap_VoucherTableColumn_TableID]
CREATE NONCLUSTERED INDEX [eap_VoucherTableColumn_TableID] ON [dbo].[eap_VoucherTableColumn] ([TableID] ASC