库是否存在
if exists(select * from master..sysdatabases where name=N"库名")
print "exists"
else
print "not exists"
---------------
-- 判断要创建的表名是否存在
if exists (select * from dbo.sysobjects where id = object_id(N"[dbo].[表名]") and OBJECTPROPERTY(id, N"IsUserTable") = 1)
-- 删除表
drop table [dbo].[表名]
GO
---------------
-----列是否存在
IF COL_LENGTH( "表名","列名") IS NULL
PRINT "not exists"
ELSE
PRINT "exists"
alter table 表名 drop constraint 默认值名称
go
alter table 表名 drop column 列名
go
-----
--判断要创建临时表是否存在
If Object_Id("Tempdb.dbo.#Test") Is Not Null
Begin
print "存在"
End
Else
Begin
print "不存在"
End
---------------
-- 判断要创建的存储过程名是否存在
if exists (select * from dbo.sysobjects where id = object_id(N"[dbo].[存储过程名]") and OBJECTPROPERTY(id, N"IsProcedure") = 1)
-- 删除存储过程
drop procedure [dbo].[存储过程名]
GO
---------------
-- 判断要创建的视图名是否存在
if exists (select * from dbo.sysobjects where id = object_id(N"[dbo].[视图名]") and OBJECTPROPERTY(id, N"IsView") = 1)
-- 删除视图
drop view [dbo].[视图名]
GO
---------------
-- 判断要创建的函数名是否存在
if exists (select * from sysobjects where xtype="fn" and name="函数名")
if exists (select * from dbo.sysobjects where id = object_id(N"[dbo].[函数名]") and xtype in (N"FN", N"IF", N"TF"))
-- 删除函数
drop function [dbo].[函数名]
GO
if col_length("表名", "列名") is null
print "不存在"
select 1 from sysobjects where id in (select id from syscolumns where name="列名") and name="表名"
如果觉得《sqlserver 各种判断是否存在(表名 函数 存储过程.......)》对你有帮助,请点赞、收藏,并留下你的观点哦!