–查询SQL库中是否存在数据库
select COUNT(*) from master..sysdatabases where name=N’REPORT’;
–表名是否存在
select COUNT(*) from dbo.sysobjects where id = object_id(N’[dbo].[REPORT]’) and OBJECTPROPERTY(id, N’IsUserTable’) =1
—判断要创建的存储过程名是否存在
select count(*) from dbo.sysobjects where id = object_id(N’[dbo].[存储过程名]’) and OBJECTPROPERTY(id, N’IsProcedure’) = 1
–判断视图是否存在
select COUNT(*) from dbo.sysobjects where id = object_id(N’[dbo].[视图名]’) and OBJECTPROPERTY(id, N’IsView’) = 1
–函数名是否存在
select * from sysobjects where xtype=’fn’ and name=’函数名’
select * from dbo.sysobjects where id = object_id(N’[dbo].[函数名]’) and xtype in (N’FN’, N’IF’, N’TF’))
–drop function [dbo].[函数名]