/SQL/Sql drop view if exists

Sql drop view if exists

Sql drop view if exists

DROP VIEW IF EXISTS yourview;

0

Source: sqlservertutorial.net

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

0

Source: stackoverflow.com

Similar codes

10 votes391 views2 answers
Mysql remove only_full_group_by permanently
SQL
0 vote338 views1 answer
Convert rows into columns in oracle
SQL
0 vote350 views1 answer
How to find username and password in oracle 18c
SQL
0 vote369 views1 answer
Sql contains numeric characters
SQL
4 votes343 views1 answer
Sql query to make a existing column auto increment
SQL
0 vote338 views1 answer
How to import sqlite driver class in java using maven
SQL
0 vote371 views1 answer
Postgresql port 5432 not open
SQL
0 vote381 views1 answer
Python sql passer des parametres dans une requet pymysql
SQL
0 vote359 views1 answer
Ver usuarios mysql
SQL
1 vote332 views1 answer
How to see all table partition in oracle
SQL

Share