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

4 votes238 views1 answer
Postgres delete last row
SQL
0 vote213 views1 answer
Mysql delete entire row on condition
SQL
0 vote207 views1 answer
Contact mysql column field
SQL
14 votes228 views4 answers
Sql compiler
SQL
0 vote202 views1 answer
Permission denied postgres \copy csv command line
SQL
79 votes374 views6 answers
Grepper code
SQL
1 vote224 views1 answer
Floor function in sql oracle
SQL
0 vote207 views1 answer
Grepper sql workbench download
SQL
3 votes207 views1 answer
Fk in insert mysql
SQL
0 vote182 views1 answer
Sort by last two number sql
SQL