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 vote361 views1 answer
Closure in sql
SQL
1 vote358 views1 answer
Mysql show attributes of a table
SQL
0 vote342 views1 answer
Mysql group by range
SQL
2 votes408 views2 answers
MySql FULL OUTER JOIN
SQL
0 vote334 views1 answer
How to write triggers to increment or decrement the number of employees
SQL
3 votes342 views2 answers
Oracle apex view logs
SQL
0 vote359 views1 answer
Oracle select partition
SQL
5 votes343 views2 answers
Mysql date greater than 30 days
SQL
3 votes346 views1 answer
Oracle get trigger ddl
SQL
0 vote377 views1 answer
Sql with example
SQL