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 vote313 views2 answers
Mysql get day of week
SQL
4 votes285 views2 answers
Oracle last day of month
SQL
0 vote278 views1 answer
FIND LOWEST SALARY EARNER IN SQL
SQL
0 vote280 views1 answer
Hibernate show sql xml property
SQL
1 vote273 views1 answer
Error code 1175 mysql fix
SQL
0 vote277 views1 answer
Sql bild in function
SQL
0 vote271 views1 answer
18446744073709551615 mariadb left join order by
SQL
1 vote279 views1 answer
How-can-i-start-postgresql-server-on-mac-os-x
SQL
0 vote288 views1 answer
SQL SERVER xquery count child nodes
SQL
3 votes304 views2 answers
Oracle sql first day of month
SQL