
delete from [dbo].[pal_SurfaceField]
where surfaceFieldName = 'ShoppingListSearchHistoryItems_ProductSearchHistoryItems_ShoppingListNumber'
or surfaceFieldName = 'ShoppingListSearchHistoryItems_ProductSearchHistoryItems_RetailerName'
or surfaceFieldName = 'ShoppingListSearchHistoryItems_ProductSearchHistoryItems_DateCreated'
or surfaceFieldName = 'ShoppingListSearchHistoryItems_ProductSearchHistoryItems_SearchName'
or surfaceFieldName = 'ShoppingListSearchHistoryItems_ProductSearchHistoryItems_Barcode'
or surfaceFieldName = 'ShoppingListSearchHistoryItems_ProductSearchHistoryItems_CostPrice';

alter table [dbo].[publ_ShoppingListSearchHistoryItems]
drop column ShoppingListSearchHistoryItems_ProductSearchHistoryItems_ShoppingListNumber;

alter table [dbo].[publ_ShoppingListSearchHistoryItems]
drop column ShoppingListSearchHistoryItems_ProductSearchHistoryItems_RetailerName;

alter table [dbo].[publ_ShoppingListSearchHistoryItems]
drop column ShoppingListSearchHistoryItems_ProductSearchHistoryItems_DateCreated;

alter table [dbo].[publ_ShoppingListSearchHistoryItems]
drop column ShoppingListSearchHistoryItems_ProductSearchHistoryItems_SearchName;

alter table [dbo].[publ_ShoppingListSearchHistoryItems]
drop column ShoppingListSearchHistoryItems_ProductSearchHistoryItems_Barcode;

alter table [dbo].[publ_ShoppingListSearchHistoryItems]
drop column ShoppingListSearchHistoryItems_ProductSearchHistoryItems_CostPrice;