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

21 votes110 views2 answers
Typescript array insert
TypeScript
0 vote141 views1 answer
No database host was found that meets the requirements for this server.
TypeScript
0 vote154 views1 answer
Lodash typescript
TypeScript
0 vote121 views1 answer
Interaction of pc hardware components in the pc boot
TypeScript
1 vote101 views1 answer
Nodejs terminate the worker thread
TypeScript
0 vote104 views1 answer
Install vsts client version 14.102.0
TypeScript
0 vote120 views1 answer
How to return multiple components in react
TypeScript
0 vote112 views1 answer
TypeScript interface for object with arbitrary numeric property names?
TypeScript
-1 vote115 views1 answer
Splice typescript array
TypeScript
-1 vote99 views1 answer
Typescript dictionary contains key
TypeScript