DROP VIEW IF EXISTS yourview;
if exists(select 1 from sys.views where name='tst' and type='v') drop view tst; go create view tst as select * from test