Table drop if exist sql server

DROP TABLE IF EXISTS dbo.Customers

Source: sqlhints.com

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

DROP TABLE IF EXISTS dbo.Scores

Source: stackoverflow.com

-- 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;

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

Source: stackoverflow.com

DROP TABLE IF EXISTS my_table;

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

Source: stackoverflow.com

Similar codes

0 vote266 views2 answers
How to combine diff colmun value using group by postgres
SQL
13 votes299 views3 answers
Mysqldump structure only
SQL
1 vote336 views1 answer
Mysql get max value and id
SQL
0 vote297 views1 answer
Hue hive UploadingTextFiletoHive
SQL
0 vote283 views1 answer
Error code 1241 mysql
SQL
0 vote263 views1 answer
Get record which is available in one table but not in another mysql
SQL
4 votes281 views4 answers
Start mysql
SQL
2 votes260 views2 answers
How to view created temporary tables in mysql
SQL
1 vote268 views1 answer
Mysql select if empty result
SQL
0 vote299 views1 answer
How to fetch data from database in sql
SQL