- - - - - - - - - -- - - - - - - -- -- - - - - - - - - - - - - - - - - - - - - - -- - - - - ---- - - -- --- -
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' }
]
]
]
]
语法:
EXECUTE sp_addextendedproperty N'MS_Description', N' 字段注释 ', N'user', N'dbo', N'table', N' 表名 ', N'column', N' 字段名 '
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' }
]
]
]
]
语法:
EXECUTE sp_addextendedproperty N'MS_Description', N' 字段注释 ', N'user', N'dbo', N'table', N' 表名 ', N'column', N' 字段名 '
- - - - - - - - - -- - - - - - - -- -- - - - - - - - - - - - - - - - - - - - - - -- - - - - ---- - - -- --- -
- - - - - - - - - -- - - - - - - -- -- - - - - - - - - - - - - - - - - - - - - - -- - - - - ---- - - -- --- -
SELECT
A.name AS table_name,
B.name AS column_name,
C.value AS column_description
FROM sys.tables A
INNER JOIN sys.columns B ON B.object_id = A.object_id
LEFT JOIN sys.extended_properties C ON C.major_id = B.object_id AND C.minor_id = B.column_id
WHERE A.name = '表名'
- - - - - - - - - -- - - - - - - -- -- - - - - - - - - - - - - - - - - - - - - - -- - - - - ---- - - -- --- -