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 vote224 views1 answer
Oracle execute package dblink
SQL
0 vote222 views1 answer
Restart postgresql.service Failed to restart postgresql.service: Unit not found.
SQL
4 votes227 views2 answers
Tables in sql
SQL
0 vote233 views1 answer
How to put 0 or 000 depending IDCustomer length in sql server
SQL
9 votes241 views3 answers
Show table columns mysql command line
SQL
19 votes219 views6 answers
Laravel sql query
SQL
3 votes256 views1 answer
APEX elapsed time
SQL
27 votes237 views4 answers
Get all tables with column name sql
SQL
0 vote241 views1 answer
How to print mysql query of codeigniter query builder
SQL
5 votes227 views1 answer
Ascending order and where in sql
SQL