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 vote260 views1 answer
Time mysql w3
SQL
0 vote267 views1 answer
Example of sql querry result sepapreted by comma
SQL
0 vote278 views1 answer
Select from column mysql
SQL
0 vote280 views1 answer
List all permissions on a table in postgres
SQL
1 vote274 views1 answer
Importance of comment in mysql
SQL
1 vote284 views1 answer
Trim leading zeros in sql
SQL
4 votes306 views1 answer
What are the data types
SQL
21 votes268 views3 answers
Average sql
SQL
3 votes254 views1 answer
Insert into table from another table mysql
SQL
1 vote319 views1 answer
Create email address from first and last name in sql
SQL