Alter
table
TSK_REPORT
drop
column
DATA_ATT_ID
--
删除某一列
Alter
table
TSK_REPORT
add
DATA_ATT_ID
nvarchar
(
50
)
--
添加某一列
给此列加注释
EXECUTE
sp_addextendedproperty
N
'
MS_Description
'
,
'
外协任务的上传文件的附件id
'
, N
'
user
'
, N
'
dbo
'
, N
'
table
'
, N
'
TSK_REPORT
'
, N
'
column
'
, N
'
DATA_ATT_ID
'
![](https://i-blog.csdnimg.cn/blog_migrate/4f1150b881333f12a311ae9ef34da474.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/4f1150b881333f12a311ae9ef34da474.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/4f1150b881333f12a311ae9ef34da474.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/4f1150b881333f12a311ae9ef34da474.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/4f1150b881333f12a311ae9ef34da474.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/4f1150b881333f12a311ae9ef34da474.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/4f1150b881333f12a311ae9ef34da474.gif)