获取table 的列信息

Select o.name AS tableName,
c.name AS columnName,
p.[value] AS Description
FROM  sys.extended_properties p
inner JOIN
sysobjects o
ON o.id = p.major_id
inner JOIN
syscolumns c
ON  p.minor_id = c.colid and o.id=c.id
AND (o.name = 'ActualReturnMoney')
order  BY o.name

posted @ 2012-10-26 17:54  (二少)在南极  阅读(152)  评论(0编辑  收藏  举报