Sql server drop table if exists

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;

T-sql drop function if exists

IF EXISTS (
    SELECT * FROM sysobjects WHERE id = object_id(N'function_name') 
    AND xtype IN (N'FN', N'IF', N'TF')
)
    DROP FUNCTION function_name
GO

Source: stackoverflow.com

Sql drop table if exists

IF OBJECT_ID('dbo.Scores', 'U') IS NOT NULL 
  DROP TABLE dbo.Scores;

Source: stackoverflow.com

Similar codes

2 votes114 views2 answers
Sql strip non alphanumeric characters
SQL
16 votes125 views6 answers
Your connection attempt failed for user 'root' to the mysql server at localhost 3306
SQL
16 votes128 views5 answers
Select last row in sql
SQL
2 votes116 views2 answers
How to add not null constraint in sql
SQL
9 votes104 views3 answers
Where in sql
SQL
10 votes106 views1 answer
User_dependencies
SQL
25 votes109 views3 answers
How to use a database to see tables mysql
SQL
2 votes121 views2 answers
Sqlalchemy return id after insert
SQL
0 vote105 views1 answer
Select from another database
SQL
0 vote117 views1 answer
How to run mysql in git bash
SQL