/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

8 votes330 views1 answer
Oracle add datafile to tablespace
SQL
0 vote334 views1 answer
How to check database engine in mysql
SQL
2 votes306 views6 answers
In operator in sql
SQL
2 votes307 views1 answer
Oracle list grants on package
SQL
0 vote292 views1 answer
How to update random rows in sql
SQL
7 votes334 views1 answer
Mysql remote connection command line
SQL
2 votes329 views1 answer
Metasploit start postgresql
SQL
0 vote310 views1 answer
Shell script to log mysql cpu usage
SQL
0 vote326 views1 answer
Sqlite3_open_v2
SQL
19 votes323 views3 answers
Grant mysql
SQL

Share