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 vote93 views1 answer
Order documents in firestore
TypeScript
1 vote102 views1 answer
Count objects in selenium java
TypeScript
2 votes108 views2 answers
Typescript property state does not exist
TypeScript
0 vote88 views1 answer
Angular firestore timestamp date pipe
TypeScript
0 vote103 views1 answer
Sarasota bowling alley bomb threats incident
TypeScript
0 vote147 views1 answer
Deep partial typescript
TypeScript
2 votes102 views1 answer
Ts-node call function from command line
TypeScript
0 vote109 views1 answer
How to pass data to another page in ionic 3
TypeScript
3 votes111 views2 answers
How to Remove undefined Values From a JavaScript Array?
TypeScript
1 vote146 views1 answer
Andonis many to many detach
TypeScript