Search
 
SCRIPT & CODE EXAMPLE
 

SQL

sql drop view if exists

DROP VIEW IF EXISTS yourview;
Comment

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
Comment

PREVIOUS NEXT
Code Example
Sql :: mysql allow remote connections 
Sql :: mysql last 6 months 
Sql :: oracle check table lock 
Sql :: oracle service name view 
Sql :: oracle table statistics last analyzed 
Sql :: sql between date range 
Sql :: mysql import ignore errors 
Sql :: mysql import gzip db 
Sql :: oracle sql first day of month 
Sql :: how to get last row of table in sql 
Sql :: change mysql password from command line 
Sql :: mysql increment value by 1 in update 
Sql :: file /etc/init.d/mysql not exists 
Sql :: command line mysql import 
Sql :: Sql query to force the database to be drop 
Sql :: pyodbc connect to sql server 
Sql :: ORACLE RIGHT TWO DIGITS 
Sql :: how much every mysql database record takes from diskspace 
Sql :: show sqlite column names 
Sql :: invalid reference to FROM-clause entry for table "unidades 
Sql :: django sqllite config 
Sql :: query any digits record 
Sql :: get the mysql table columns data type mysql 
Sql :: python how to connect to sql server 
Sql :: display users in mysql 
Sql :: reutrn string after character sql 
Sql :: sql get guid 
Sql :: mysql int range 
Sql :: sql get number of days between two dates 
Sql :: sql query inline if 
ADD CONTENT
Topic
Content
Source link
Name
7+8 =