/****** Object:  Index [IX_PG_FORN_PG_CRED_SALDO_ABERTO]    Script Date: 08/15/2012 14:24:08 ******/
IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[PG_FORN_PG_CRED_SALDO_ABERTO]') AND name = N'IX_PG_FORN_PG_CRED_SALDO_ABERTO')
ALTER TABLE dbo.PG_FORN_PG_CRED_SALDO_ABERTO
	DROP CONSTRAINT IX_PG_FORN_PG_CRED_SALDO_ABERTO
GO
ALTER TABLE dbo.PG_FORN_PG_CRED_SALDO_ABERTO ADD CONSTRAINT
	IX_PG_FORN_PG_CRED_SALDO_ABERTO UNIQUE NONCLUSTERED 
	(
	DT_MOV,
	CD_BANDEIRA,
	CD_FORN,
	TP_TRANSACAO,
	CD_EMP
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
