给字段添加说明吧,给你一个sql语句例子吧如下:
/****** Object: Table [dbo].[t1] Script Date: 2005-3-15 10:52:32 ******/
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)