sql drop table if exists
DROP TABLE IF EXISTS dbo.Customers
sql drop table if exists
DROP TABLE IF EXISTS dbo.Customers
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
sql drop table if exists
IF OBJECT_ID('dbo.Scores', 'U') IS NOT NULL
DROP TABLE dbo.Scores;
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;
if table exists drop
IF EXISTS(SELECT *
FROM dbo.Scores)
DROP TABLE dbo.Scores
Copyright © 2021 Codeinu
Forgot your account's password or having trouble logging into your Account? Don't worry, we'll help you to get back your account. Enter your email address and we'll send you a recovery link to reset your password. If you are experiencing problems resetting your password contact us