UPDATE t SET t.isActive = 1 
FROM pal_SurfaceFieldType t 
WHERE t.surfaceFieldType = 'RadioButtonList' 



IF EXISTS ( SELECT * 
            FROM   sysobjects 
            WHERE  id = object_id(N'[dbo].[v_SalesView]') 
                   and OBJECTPROPERTY(id, N'IsView') = 1 )
BEGIN
    DROP VIEW [dbo].[v_SalesView]
END