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

3 votes209 views1 answer
APEX elapsed time
SQL
0 vote196 views1 answer
Linked server delete openquery
SQL
0 vote195 views2 answers
How to combine diff colmun value using group by postgres
SQL
0 vote259 views1 answer
Split first name and last name in sql
SQL
0 vote202 views1 answer
Windows aggregate functions in postgresql
SQL
3 votes185 views2 answers
Coalesce mysql
SQL
0 vote196 views1 answer
Execute sql stored procedure in powershell
SQL
1 vote191 views2 answers
Postgresql get difference in hours between two dates
SQL
1 vote204 views1 answer
Mysql print variable
SQL
1 vote226 views1 answer
Sql select row with max date
SQL