IF  EXISTS (
 SELECT * FROM sys.indexes  WHERE UPPER(NAME)  = 'EST_SNGPC_ENTRADA_idx')
DROP INDEX [EST_SNGPC_ENTRADA_idx] ON [dbo].[EST_SNGPC_ENTRADA]



GO

CREATE NONCLUSTERED INDEX [EST_SNGPC_ENTRADA_idx] ON [dbo].[EST_SNGPC_ENTRADA]
  ([CD_EMP], [CD_FILIAL], [CD_NF], [CD_PROD])
WITH (
  PAD_INDEX = OFF,
  DROP_EXISTING = OFF,
  STATISTICS_NORECOMPUTE = OFF,
  SORT_IN_TEMPDB = OFF,
  ONLINE = OFF,
  ALLOW_ROW_LOCKS = ON,
  ALLOW_PAGE_LOCKS = ON)
ON [PRIMARY]
GO