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

3 votes132 views1 answer
Arraylist of objects in java
TypeScript
0 vote173 views1 answer
Haskell get specific elements of a String
TypeScript
0 vote125 views1 answer
Name all the elements of set Red. Use the proper set notation.
TypeScript
1 vote182 views1 answer
Powershell script remove directory recursive
TypeScript
0 vote137 views1 answer
Where do you store your test data
TypeScript
3 votes153 views2 answers
Removing directories in linux
TypeScript
0 vote124 views1 answer
(!) Plugin typescript: @rollup/plugin-typescript TS2307: Cannot find module './App.svelte' or its corresponding type declarations. src/main.ts: (1:17)
TypeScript
0 vote147 views1 answer
Const formats = { time: { '24hour': {hour12: false, hours: 'numeric', minute: 'numeric'} } }; <IntlProvider locale={locale} messages={messages} formats={formats}> <FormattedTime value={someDate} format='24hour'/> </IntlProvider>
TypeScript
18 votes118 views2 answers
Fluttter http get
TypeScript
1 vote121 views2 answers
Downloading youtube playlists using youtube-dl in highest quality
TypeScript