IF EXISTS ( SELECT * 
            FROM   sys.views 
            WHERE  name='pal_vUserShared' and type='v')
BEGIN
    DROP VIEW [dbo].[pal_vUserShared]
END
