sql中语句修改字段注释

--1、创建登录日志表
IF OBJECT_ID('oa_login_log') IS NOT NULL
DROP TABLE oa_login_log;
CREATE TABLE oa_login_log
(
id	int PRIMARY KEY IDENTITY(1,1),
client_ip	varchar(20),
original_loginname	varchar(20),
loginname	varchar(20),
data_status	bit default(0),
gmt_create	datetime default(getdate()),
gmt_modified	datetime default(getdate()),
db_time_stamp	timestamp
)
GO
--注释
EXEC sys.sp_addextendedproperty @name='MS_Description', @value='OA系统登录日志表', @level0type='SCHEMA',@level0name='dbo', @level1type='TABLE',@level1name='oa_login_log';

EXEC sys.sp_addextendedproperty @name='MS_Description', @value='主键，编号', @level0type='SCHEMA',@level0name='dbo', @level1type='TABLE',@level1name='oa_login_log',@level2type='COLUMN', 
@level2name='id';
EXEC sys.sp_addextendedproperty @name='MS_Description', @value='客户端请求IP', @level0type='SCHEMA',@level0name='dbo', @level1type='TABLE',@level1name='oa_login_log',@level2type='COLUMN', 
@level2name='client_ip';
EXEC sys.sp_addextendedproperty @name='MS_Description', @value='原登录用户名', @level0type='SCHEMA',@level0name='dbo', @level1type='TABLE',@level1name='oa_login_log',@level2type='COLUMN', 
@level2name='original_loginname';
EXEC sys.sp_addextendedproperty @name='MS_Description', @value='切换登录用户名', @level0type='SCHEMA',@level0name='dbo', @level1type='TABLE',@level1name='oa_login_log',@level2type='COLUMN', 
@level2name='loginname';
EXEC sys.sp_addextendedproperty @name='MS_Description', @value='数据状态', @level0type='SCHEMA',@level0name='dbo', @level1type='TABLE',@level1name='oa_login_log',@level2type='COLUMN', 
@level2name='data_status';
EXEC sys.sp_addextendedproperty @name='MS_Description', @value='创建时间', @level0type='SCHEMA',@level0name='dbo', @level1type='TABLE',@level1name='oa_login_log',@level2type='COLUMN', 
@level2name='gmt_create';
EXEC sys.sp_addextendedproperty @name='MS_Description', @value='时间戳', @level0type='SCHEMA',@level0name='dbo', @level1type='TABLE',@level1name='oa_login_log',@level2type='COLUMN', 
@level2name='db_time_stamp';