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

12 votes206 views3 answers
Remove dots from li
TypeScript
0 vote193 views1 answer
Declaration of instance field not allowed after declaration of instance method. Instead, this should come at the beginning of the class/interface
TypeScript
0 vote191 views2 answers
Typescript one of the array items
TypeScript
1 vote207 views1 answer
Typescript string null or white space
TypeScript
1 vote207 views4 answers
How to execute scripts when a button gui is pressed roblox
TypeScript
0 vote299 views1 answer
> Could not find method classpath() for arguments [org.jetbrains.kotlin:kotlin-gradle-plugin:1.6.10] on object of type org.gradle.api.internal.artifacts.dsl.dependencies.DefaultDependencyHandler.
TypeScript
0 vote218 views1 answer
How to Write a program that accepts three decimal numbers as input and outputs their sum on python
TypeScript
0 vote203 views1 answer
Symfony assets install
TypeScript
3 votes185 views2 answers
Enum
TypeScript
39 votes261 views5 answers
AppData\Roaming\npm\ng.ps1 cannot be loaded because running scripts is disabled on this system.
TypeScript