--查看字段说明
SELECT t.[name] AS [表名],c.[name] AS [字段名],cast(ep....[value]
as varchar(100)) AS [字段说明]
FROM sys.tables AS t INNER JOIN sys.columns
AS c ON t.object_id...[name] in ('字段名','字段名')
--新增字段说明
EXEC
sys.sp_addextendedproperty @name=N'MS_Description',
@value=N...'字段说明' , @level0type=N'SCHEMA',@level0name=N'dbo',
@level1type=N'TABLE',@level1name=N'表名', @level2type...=N'COLUMN',
@level2name=N'字段名'
GO
--修改字段说明
BEGIN TRANSACTION
GO
DECLARE @v sql_variant
SET @v =