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

23 votes116 views3 answers
Mysqldump
SQL
0 vote138 views2 answers
How do I install microsoft SQL on my Mac?
SQL
0 vote166 views2 answers
Impala rename column name
SQL
0 vote166 views1 answer
How to remove quotes from a string in ssis load file
SQL
0 vote104 views1 answer
Bigquery information_schema schema all columns
SQL
0 vote154 views1 answer
How to create a new shema using query languaage
SQL
0 vote162 views1 answer
Error: SAP DBTech JDBC: [258]: insufficient privilege: Detailed info for this error can be found with guid '87813FAA56439F48BD60812F3EBEC5A4'
SQL
1 vote147 views1 answer
Access denied for user 'root'@'localhost' python sql-connect error
SQL
17 votes142 views6 answers
Sql select distinct
SQL
0 vote178 views1 answer
Mysql best varchar length size
SQL