22,209
社区成员
发帖
与我相关
我的任务
分享
Select name from syscolumns Where ID=OBJECT_ID('ZC_Admission')
ID
ClasssetupID
NurseryID
SpecialtysetupID
CarsetupID
Adname
Adcode
Adsex
Adtime
ID 编号
ClasssetupID 班级
NurseryID 入托方式
SpecialtysetupID 特长班级
CarsetupID 接送方式
Adname 姓名
Adcode 拼音码
Adsex 性别
Adtime 时间
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'说明' , @level0type=N'SCHEMA',@level0name=N'架构名', @level1type=N'TABLE',@level1name=N'表名', @level2type=N'COLUMN',@level2name=N'列名'
GO
--例如
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZC_Admission', @level2type=N'COLUMN',@level2name=N'ID'
GO
SELECT t.name AS [表名]
,c.name AS [字段名]
,fv.colname AS [字段说明]
FROM sys.tables AS t
INNER JOIN sys.columns AS c
ON t.object_id = c.object_id
LEFT JOIN fieldvalue AS fv
ON fv.tbid = c.object_id AND fv.colid = c.column_id
WHERE t.name='ZC_Admission'
--2000
Select a.name,b.value
from syscolumns a left join sysproperties b
on a.id=b.id AND a.colid = b.smallid
Where a.ID=OBJECT_ID('tb')
--2005
Select a.name,b.value
from sys.syscolumns a left join sys.extended_properties b
on a.id=b.major_id AND a.colid = b.minor_id
Where a.ID=OBJECT_ID('tb')
如果在描述那里,可以用以下代码查得:
SELECT t.name AS [表名]
,c.name AS [字段名]
,ep.value AS [字段说明]
FROM sys.tables AS t
INNER JOIN sys.columns AS c
ON t.object_id = c.object_id
LEFT JOIN sys.extended_properties AS ep
ON ep.major_id = c.object_id AND ep.minor_id = c.column_id
WHERE ep.class = 1 --条件省略可以查看全部字段说明,否则只显示有说明的字段
AND t.name='ZC_Admission'