Drop table if exists

Sql drop table if exists

DROP TABLE IF EXISTS dbo.Customers

Source: sqlhints.com

Sql server drop table if exists

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

Drop table if exists

DROP TABLE IF EXISTS dbo.Scores

Source: stackoverflow.com

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;

Sql drop table if exists

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

Source: stackoverflow.com

If table exists drop

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

Source: stackoverflow.com

Similar codes

0 vote287 views1 answer
Select in select sql
SQL
0 vote290 views1 answer
Drush run sql select
SQL
0 vote292 views1 answer
Hibernate show sql xml property
SQL
0 vote245 views1 answer
Plsql trigger insert update
SQL
2 votes291 views1 answer
Illuminate\Database\QueryException : SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost'
SQL
3 votes301 views1 answer
Laravel database Using Named Bindings
SQL
0 vote298 views1 answer
Mysql extract day from date leading zero
SQL
0 vote271 views1 answer
Check mysql password with docker container magento 2
SQL
6 votes292 views1 answer
Sql insert values into table
SQL
0 vote279 views1 answer
Oracle sql generate list of days
SQL