IF EXISTS( SELECT * FROM sys.views WHERE name = 'vS' AND schema_id = SCHEMA_ID('HumanResources')) DROP VIEW HumanResources.vSGO