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

1 vote214 views1 answer
CREATE DATABASE db; SyntaxError: Unexpected identifier
SQL
0 vote232 views1 answer
Python connect microsoft sql server
SQL
0 vote237 views1 answer
Mysql join table with a text columns with ids splited by char
SQL
0 vote248 views1 answer
A good way of running a SQL query in JDBC using a parameterized statement
SQL
0 vote314 views2 answers
Https://cloud.google.com/shell/docs/using-web-preview#previewing_the_application
SQL
10 votes280 views4 answers
Join multiple tables in sql
SQL
0 vote188 views0 answer
SQL
0 vote244 views3 answers
Constraint sql
SQL
1 vote240 views1 answer
Top 10 rows in mysql
SQL
0 vote225 views1 answer
Sql server separar numeros por comas miles
SQL