

IF EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[GT05_GEDATICLIFOR]') AND name = N'IDX02_GT05')
	DROP INDEX [IDX02_GT05] ON [dbo].[GT05_GEDATICLIFOR]
GO

IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[GT05_GEDATICLIFOR]') AND name = N'IDX03_GT05')
	CREATE UNIQUE NONCLUSTERED INDEX [IDX03_GT05] ON [dbo].[GT05_GEDATICLIFOR]
	(
		GT05_DITTA ASC,
		GT05_IND_TIPO_CLIENTE_FORNITORE ASC,
		GT05_CODICEGE ASC
	)
GO
