t-sql delete view if exists

Jealous Jackal answered on March 30, 2020 Popularity 8/10 Helpfulness 5/10

answer t-sql delete view if exists

related sql drop view if exists

Comment

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

create view tst
as
select * from test

Popularity 8/10 Helpfulness 5/10 Language sql

Tags: exists sql view

Link to this answer
Share Copy Link

Contributed on Mar 30 2020

Jealous Jackal

0 Answers Avg Quality 2/10

Closely Related Answers

Comment

DROP VIEW IF EXISTS yourview;

Popularity 9/10 Helpfulness 10/10 Language sql

Tags: exists ex

Link to this answer
Share Copy Link

Contributed on Apr 17 2021

Defiant Dove

0 Answers Avg Quality 2/10