sql-server - 如何检查 sql server 对象是否存在并删除它？

Question

编辑 : 函数创建丢失，抱歉

我有一个 T-SQL 请求:

DECLARE @IsSomething bit
SET @IsSomething = 0
IF /some tests/ SET @IsSomething = 1
EXEC('
CREATE FUNCTION IsSomething ()
RETURNS bit
AS
BEGIN
    RETURN ' + @IsSomething + '
END')

当然，如果我运行它两次，我会得到

There is already an object named 'IsSomething ' in the database. 

我将如何做这样的事情:

IF EXIST @IsSomething DESTROY @IsSomething // (Pseudo bad code)

Answer 1

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id (N'[dbo].[IsSomething]') AND OBJECTPROPERTY(id, N'IsFunction') = 1) 

DROP function IsSomething
GO