Answers for "creating a view that that must not be dropped if it already exists in sql"

t-sql delete view if exists

if exists(select 1 from sys.views where name='tst' and type='v')
drop view tst;
go

create view tst
as
select * from test

Posted by: Guest on March-30-2020

Code answers related to "creating a view that that must not be dropped if it already exists in sql"