每一个数据表 添加一个 扩展 属性：Description  填写表描述。

查看是否所有表都添加的Sql如下：

 

SELECT a.name AS name, g.[value]	FROM sys.tables a 	LEFT JOIN	(SELECT * FROM sys.extended_properties WHERE NAME='Description' ) g		ON (a.object_id = g.major_id AND g.minor_id = 0)	WHERE a.name NOT IN('sysdiagrams','ASPStateTempSessions','ASPStateTempApplications')	AND g.value IS NULL	ORDER BY a.name

　　

查看所有表名称描述：

　　

SELECT a.name AS name, g.[value]	FROM sys.tables a 	LEFT JOIN	(SELECT * FROM sys.extended_properties WHERE NAME='Description' ) g		ON (a.object_id = g.major_id AND g.minor_id = 0)	WHERE a.name NOT IN('sysdiagrams','ASPStateTempSessions','ASPStateTempApplications')	ORDER BY a.name