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

-1 vote285 views1 answer
Auto increment psql not primary key
SQL
1 vote291 views2 answers
Duplicate key value violates unique constraint "django_admin_log_pkey"
SQL
0 vote253 views1 answer
Check duplicate values plsql
SQL
1 vote259 views3 answers
Grant syntax in sql
SQL
5 votes261 views1 answer
Ignore duplicate rows in sqlite
SQL
10 votes269 views3 answers
Sql select between two dates
SQL
0 vote279 views1 answer
Find how many tables in database sql query
SQL
2 votes260 views1 answer
Merge two columns in sql oracle
SQL
1 vote279 views1 answer
Oracle truncate partition
SQL
0 vote352 views1 answer
Create view in sql server that contain multiple select statements
SQL