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 vote147 views1 answer
Sqlite insert or update
SQL
0 vote158 views1 answer
Find duplicate users by email address in mysql
SQL
1 vote139 views1 answer
Mysql2::Error: Incorrect string value: '\xE2\x80\x8B
SQL
4 votes133 views1 answer
Postgresql show current database
SQL
0 vote172 views1 answer
Mysql last friday of current month
SQL
1 vote140 views1 answer
Mysql check table exists
SQL
1 vote95 views1 answer
Metada in sql
SQL
1 vote169 views1 answer
Encrypt password postgresql
SQL
1 vote230 views1 answer
Primary key reset in SQL database
SQL
0 vote149 views1 answer
Sqlalchemy get ids
SQL