SQLServer这样查表备注

SQLServer可以这样查表

select t.aname,t.adesc from(
select a.name AS aname,
CONVERT(NVARCHAR(100),isnull(g.[value],’-’)) AS adesc
from sys.tables a left join sys.extended_properties g
on (a.object_id = g.major_id AND g.minor_id = 0)) t
where t.adesc like ‘%用户%’;