Search
 
SCRIPT & CODE EXAMPLE
 

SQL

sql drop table if exists

DROP TABLE IF EXISTS dbo.Customers
Comment

sql server drop table if exists

IF OBJECT_ID('dbo.Scores', 'U') IS NOT NULL DROP TABLE dbo.Scores; 
Comment

drop table if exists

DROP TABLE IF EXISTS dbo.Scores
Comment

SQL DROP TABLE IF EXISTS

DROP TABLE IF EXISTS my_table;
Comment

sql server drop table if exists

-- Classic table
IF OBJECT_ID('my_schema.my_table', 'U') IS NOT NULL DROP TABLE my_schema.my_table; 
-- Temporary table
IF OBJECT_ID('tempdb.my_schema.#my_table') IS NOT NULL DROP TABLE #my_table; 
Comment

sql drop table if exists

IF OBJECT_ID('dbo.Scores', 'U') IS NOT NULL 
  DROP TABLE dbo.Scores; 
Comment

if table exists drop

IF EXISTS(SELECT *
          FROM   dbo.Scores)
  DROP TABLE dbo.Scores
Comment

PREVIOUS NEXT
Code Example
Sql :: sql insert query 
Sql :: How to View column names of a table in SQL 
Sql :: sqlite version check 
Sql :: sql insert timestamp 
Sql :: SQL query to convert DD/MM/YYYY to YYYY-MM-DD 
Sql :: get first 2 letter in sql 
Sql :: select tables with name like mysql 
Sql :: having vs where 
Sql :: script to add new column in table sql 
Sql :: PL SQL MODIFY COLUMN NME 
Sql :: postgresql array last element 
Sql :: show tables sql 
Sql :: how to delete git repo locally 
Sql :: sql server reseed identity column 
Sql :: oracle explain plan 
Sql :: where to locate set password for mysql 
Sql :: org.h2.jdbc.JdbcSQLSyntaxErrorException 
Sql :: sql server date format dd/mm/yyyy 
Sql :: oracle last day of month 
Sql :: how to export table data from mysql table in sql format 
Sql :: sql problems 
Sql :: MySQL shutdown unexpectedly. 
Sql :: SQL: merging multiple row data in string 
Sql :: postgres alter table owner 
Sql :: mysql start command 
Sql :: pandas to sql index 
Sql :: mysql change collation one column 
Sql :: postgres default user 
Sql :: postgresql extract hour and minutes from timestamp 
Sql :: (PDOException(code: 2002): SQLSTATE[HY000] [2002] Permission denied at 
ADD CONTENT
Topic
Content
Source link
Name
7+1 =