T-sql drop function 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;

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

0 vote122 views1 answer
How to get initials in sql
SQL
1 vote136 views1 answer
Isnull sql server
SQL
0 vote149 views1 answer
Sort by
SQL
1 vote157 views1 answer
Get current date in pyspark sql
SQL
3 votes139 views2 answers
Df to sql pandas sql achemy
SQL
18 votes133 views4 answers
Mysql current date between two dates
SQL
1 vote126 views1 answer
Set all the vluses in calumn in sql to false
SQL
0 vote128 views1 answer
Create table if not exist with exceptions
SQL
1 vote142 views1 answer
Mysql how to truncate table with foreign keys
SQL
4 votes126 views3 answers
Sql drop database if exists
SQL