if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[T_TestTable]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
![](/Images/OutliningIndicators/None.gif)
if ( NOT exists ( select * from dbo.syscolumns where name = ' sum ' and id in
(
select
id
from
dbo.sysobjects
where
id
=
object_id
(N
'
[dbo].[T_TestTable]
'
)
and
OBJECTPROPERTY
(id, N
'
IsUserTable
'
)
=
1
))
)
ALTER
TABLE
[
dbo
]
.
[
T_TestTable
]
ADD
sum
float
GO
![](/Images/OutliningIndicators/None.gif)
if ( NOT exists ( select * from dbo.syscolumns where name = ' sum ' and id in
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
简单记录一下,不知道有没有其他的缺陷,反正暂时是可以运行的,如果有错,请指教,本人sql语句不怎么样。总感觉这语句不好。
修改已存在的列的列名:sp_rename 'T_INFO_TestTable.HouseNo','HouseNONew','column' ;
GO