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 vote161 views1 answer
Hangfire clean script
SQL
0 vote223 views1 answer
Plsql check how much space all databases are consuming
SQL
0 vote301 views1 answer
Postgres list all stored procedures query
SQL
0 vote831 views2 answers
Remove mysql workbench ubuntu
SQL
0 vote201 views1 answer
Postgresql import a database of gzip
SQL
0 vote180 views1 answer
Mysql set column equal to another automatic
SQL
1 vote203 views2 answers
Full join
SQL
1 vote185 views1 answer
Expression number 1 of select list is not in group by clause
SQL
3 votes187 views1 answer
Locate sql server
SQL
0 vote197 views1 answer
Mysql range of dates overlap
SQL