|
|
库是否存在
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
=
'表名'
|
本文转自lpxxn博客园博客，原文链接：http://www.cnblogs.com/li-peng/archive/2013/01/24/2874517.html，如需转载请自行联系原作者
![[MySQL]存储过程](https://ucc.alicdn.com/3mfxe2r26qbaq/developer-article1632621/20241101/f9e47d1cdc9947d492b09f397a02c7b6.jpeg?x-oss-process=image/resize,h_160,m_lfit)
![2024Mysql And Redis基础与进阶操作系列（9）作者——LJS[含MySQL存储过程之局部、系统变量、参数传递、流程控制-判断/case具体详步骤；注意点及常见报错问题所对应的解决方法]](https://ucc.alicdn.com/pic/developer-ecology/56pfyutwi4tv4_c53df19098d2427391fe36eeb35f84c8.png?x-oss-process=image/resize,h_160,m_lfit)