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

1 vote398 views2 answers
Begin transaction sql
SQL
15 votes309 views2 answers
Open postgress in terminal mac
SQL
0 vote370 views1 answer
Insert into using contant values and source table columns with sql
SQL
0 vote356 views1 answer
"Hello User Name"
SQL
0 vote322 views1 answer
Drop procedure sql
SQL
2 votes347 views2 answers
Sqlalchemy return id after insert
SQL
0 vote313 views1 answer
Syntax for changing column size in mysql
SQL
0 vote303 views1 answer
Mysql installer no packages found
SQL
0 vote377 views1 answer
SQLSTATE[42S02]: Base table or view not found: 1146 Tabl
SQL
1 vote341 views1 answer
Oracle get current schema
SQL