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 vote160 views1 answer
Sqlalchemy get ids
SQL
0 vote166 views1 answer
Exception message: The connection name 'SqlServices' was not found in the applications configuration or the connection string is empty.
SQL
0 vote148 views1 answer
Transaction database with php
SQL
0 vote153 views2 answers
Oracle create chain rule
SQL
0 vote151 views1 answer
Postgres set default schema
SQL
0 vote146 views1 answer
Sql contains numeric characters
SQL
31 votes214 views4 answers
Mysql grant execute
SQL
5 votes175 views2 answers
Postgresql add not null constraint
SQL
0 vote169 views1 answer
Oracle job schedules
SQL
1 vote166 views3 answers
How to truncate table with foreign key constraint
SQL