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

2 votes279 views1 answer
Codeigniter print last sql query
SQL
1 vote289 views1 answer
Age postgres
SQL
15 votes415 views2 answers
Sql order by alphabetical
SQL
1 vote305 views1 answer
Alter constraint in sql
SQL
0 vote261 views1 answer
Python mysql query where
SQL
9 votes293 views4 answers
How to alter table column name in mysql
SQL
0 vote271 views1 answer
Update sqlaclehmy sqlalchemy.orm.evaluator.UnevaluatableError: Cannot evaluate BinaryExpression with operator <function like_op at 0x03CF1DF0>
SQL
0 vote297 views5 answers
Mode sql course
SQL
9 votes291 views3 answers
Mysql show table column full description
SQL
0 vote312 views2 answers
How to truncate all table in mysql workbench
SQL