Pasted

IF NOT EXISTS(SELECT TOP 1 1 FROM sys.indexes WHERE name = 'IX_ILC_iso_country_code')
  BEGIN
    CREATE UNIQUE NONCLUSTERED INDEX IX_ILC_iso_country_code
    ON dbo.country(iso_country_code)
    WHERE iso_country_code IS NOT NULL;
  END
  
GO