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 vote331 views4 answers
First max salary in sql
SQL
4 votes318 views5 answers
Primary key
SQL
0 vote335 views2 answers
Sql last updated
SQL
7 votes306 views1 answer
Postgres base size
SQL
0 vote316 views1 answer
Select count postgres double row count > 1
SQL
1 vote333 views1 answer
SQL query to get all table records count from a database
SQL
0 vote369 views1 answer
Pgadmin postgres ERROR: database is being accessed by other users
SQL
2 votes351 views3 answers
How to check current user in mySQL
SQL
2 votes311 views2 answers
How to view created temporary tables in mysql
SQL
0 vote309 views1 answer
Excute raw query
SQL