SET ANSI_NULLS, QUOTED_IDENTIFIER ON
IF OBJECT_ID('UNIVERSALDB.dbo.B2B_PRODUCT_LISTS', 'U') IS NOT NULL
    DROP TABLE UNIVERSALDB.dbo.B2B_PRODUCT_LISTS;
GO

SELECT 
	Ref,
    SicilKodu,
    Aciklama,
    PRODUCERCODE
INTO UNIVERSALDB.dbo.B2B_PRODUCT_LISTS
FROM UNIVERSALDB.dbo.B2B_PRODUCT_LIST;
GO

CREATE INDEX IDX_B2B_PRODUCT_LISTS_SicilKodu 
    ON UNIVERSALDB.dbo.B2B_PRODUCT_LISTS (SicilKodu);
GO

CREATE INDEX IDX_B2B_PRODUCT_LISTS_PRODUCERCODE
    ON UNIVERSALDB.dbo.B2B_PRODUCT_LISTS (PRODUCERCODE);
GO