sql drop view if exists

Solutions on MaxInterview for sql drop view if exists by the best coders in the world

showing results for - "sql drop view if exists"
María Fernanda
28 Aug 2020
1DROP VIEW IF EXISTS yourview;
Simona
24 Jun 2017
1if exists(select 1 from sys.views where name='tst' and type='v')
2drop view tst;
3go
4
5create view tst
6as
7select * from test