SQL 如何给字段名加注释

2025-03-05 03:17:08
推荐回答(5个)
回答1:

用as,就是取别名,比如select name as 名字 from table 这里NAME就是中文了

回答2:

select aa as 姓名,bb as 工号

回答3:

用法如下:
sp_addextendedproperty
[ @name = ] { 'property_name' }
[ , [ @value = ] { 'value' }
[ , [ @level0type = ] { 'level0_object_type' }
, [ @level0name = ] { 'level0_object_name' }
[ , [ @level1type = ] { 'level1_object_type' }
, [ @level1name = ] { 'level1_object_name' }
[ , [ @level2type = ] { 'level2_object_type' }
, [ @level2name = ] { 'level2_object_name' }
]

回答4:

开一列remark...

回答5:

表里面没法加注释
只有查询出来的时候可以给别名