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 vote217 views1 answer
Sql getdate minus 1 day without time
SQL
0 vote216 views1 answer
Python sqlalchemy orm to select null values
SQL
0 vote201 views1 answer
Mysql trim characters
SQL
0 vote209 views2 answers
Create sequence if not exists postgres
SQL
24 votes227 views4 answers
Mysql datetime
SQL
0 vote209 views1 answer
Sql get table last modified time
SQL
2 votes210 views1 answer
Sqlite insert if not exists
SQL
0 vote205 views1 answer
Postgresql CREATE EXTENSION pgcrypto
SQL
0 vote229 views1 answer
MySQL INSERT IGNORE Statement
SQL
1 vote211 views1 answer
Convert to hexadecimal sql
SQL