If table exists drop

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 vote193 views3 answers
Linux split mp4 into 2 parts by time
TypeScript
0 vote257 views1 answer
Try out the enumerate function for yourself in this quick exercise. Complete the skip_elements function to return every other element from the list, this time using the enumerate function to check if an element is on an even position or an odd positi
TypeScript
0 vote191 views1 answer
How to Convert MATLAB Scripts to Python
TypeScript
1 vote215 views1 answer
Heterogeneous objects in java
TypeScript
1 vote190 views1 answer
Laravel update if exists or create
TypeScript
-1 vote215 views1 answer
Fwrite() expects parameter 2 to be string, array given
TypeScript
10 votes244 views2 answers
How to declare a boolean in typescript
TypeScript
0 vote174 views1 answer
Angular firestore timestamp date pipe
TypeScript
0 vote200 views1 answer
Onblur typescript
TypeScript
3 votes223 views1 answer
Regex replace certain string
TypeScript