給字段添加說明吧,給你一個sql語句例子吧如下:
CREATE TABLE [dbo].[t1] (
[a] [int] NULL ,
[b] [int] NULL ,
[c] [int] NULL
) ON [PRIMARY]
GO
exec sp_addextendedproperty N 'MS_Description ', N '字段說明 ', N 'user ', N 'dbo ', N 'table ', N 't1 ', N 'column ', N 'a '
GO
exec sp_addextendedproperty N 'MS_Description ', N '字段描述 ', N 'user ', N 'dbo ', N 'table ', N '表名 ', N 'column ', N '字段名 '
讀取
此示例列出表 "T1 "中所有列的所有擴充屬性。
CREATE table T1 (id int , name char (20))
EXEC sp_addextendedproperty 'caption ', 'Employee ID ', 'user ', dbo, 'table ', 'T1 ', 'column ', id
EXEC sp_addextendedproperty 'caption ', 'Employee Name ', 'user ', dbo, 'table ', 'T1 ', 'column ', name
SELECT *
FROM ::fn_listextendedproperty (NULL, 'user ', 'dbo ', 'table ', 'T1 ', 'column ', default)