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

3 votes166 views1 answer
Mysql cli connect with password
SQL
5 votes135 views2 answers
Mysql drop table cascade
SQL
10 votes142 views2 answers
SQL rounding numbers
SQL
0 vote141 views1 answer
Which sql statement would you use to remove a view called emp_dept_vu from your schema?
SQL
0 vote144 views1 answer
Postgresql linux password
SQL
4 votes151 views2 answers
DB::transaction
SQL
0 vote119 views1 answer
Job for mysql.service failed because the control process exited with error code.
SQL
1 vote202 views1 answer
Alter constraint postgres
SQL
5 votes125 views4 answers
Describe table postgres
SQL
0 vote93 views1 answer
Mysql workbench search all tables
SQL