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

0 vote103 views2 answers
Object map of the http parameters mutually exclusive with fromString
TypeScript
0 vote102 views1 answer
Print all objects linked list python
TypeScript
7 votes144 views4 answers
Array in typescript
TypeScript
0 vote107 views1 answer
Mat card api
TypeScript
0 vote120 views6 answers
How to find nuber of tweets per day using python
TypeScript
1 vote102 views1 answer
Python requests cookies to selenium
TypeScript
0 vote106 views1 answer
Simulate click typescript
TypeScript
0 vote98 views1 answer
Typescript dynamic type
TypeScript
2 votes110 views1 answer
Cra template-typescript cmd
TypeScript
0 vote107 views1 answer
Scripted testing and exploratory testing
TypeScript