三个视图查出所有呢

迟到的“熟客” L Server数据库字典（索引.sql）

SELECT TOP 100 PERCENT , CASE WHEN yno = 1 THEN ELSE \'\' END AS 表名, CASE WHEN yno = 1 THEN ELSE \'\' END AS 索引名称, AS 列名, yno AS 索引顺序, CASE indexkey_property(, did, yno, \'isdescending\') WHEN 1 THEN \'降序\' WHEN 0 THEN \'升序\' END AS 排序, CASE WHEN IS NULL THEN \'\' ELSE \'√\' END AS 主键, CASE INDEXPROPERTY(, , \'IsClustered\') WHEN 1 THEN \'√\' WHEN 0 THEN \'\' END AS 聚集, CASE INDEXPROPERTY(, , \'IsUnique\') WHEN 1 THEN \'√\' WHEN 0 THEN \'\' END AS 唯一, CASE WHEN IS NULL THEN \'\' ELSE \'√\' END AS 唯一约束, igFillFactor AS 填充因子, date AS 创建时间, fdate AS 更改时间FROM sindexes a INNER JOIN sindexkeys b ON = AND did = did INNER JOIN scolumns d ON = AND lid = lid INNER JOIN sobjects c ON = AND ype = \'U\' LEFT OUTER JOIN sobjects e ON = AND ype = \'UQ\' LEFT OUTER JOIN sobjects p ON = AND ype = \'PK\'WHERE (OBJECTPROPERTY(, N\'IsUserTable\') = 1) AND (OBJECTPROPERTY(, N\'IsMSShipped\') = 0) AND (INDEXPROPERTY(, , \'IsAutoStatistics\') = 0)ORDER BY , , yno

L Server数据库字典（主键.外键.约束.视图.函数.存储过程.触发器.sql）

SELECT DISTINCT TOP 100 PERCENT ype, CASE ype WHEN \'X\' THEN \'扩展存储过程\' WHEN \'TR\' THEN \'触发器\' WHEN \'PK\' THEN\'主键\' WHEN \'F\' THEN \'外键\' WHEN \'C\' THEN \'约束\' WHEN \'V\' THEN \'视图\' WHEN \'FN\'THEN \'函数-标量\' WHEN \'IF\' THEN \'函数-内嵌\' WHEN \'TF\' THEN \'函数-表值\' ELSE \'存储过程\'END AS 类型, AS 对象名, date AS 创建时间, fdate AS 更改时间, xt AS 声明语句FROM sobjects o LEFT OUTER scomments c ON = WHERE (ype IN (\'X\', \'TR\', \'C\', \'V\', \'F\', \'IF\', \'TF\', \'FN\', \'P\', \'PK\')) AND (OBJECTPROPERTY(, N\'IsMSShipped\') = 0)ORDER BY CASE ype WHEN \'X\' THEN \'扩展存储过程\' WHEN \'TR\' THEN \'触发器\' WHEN\'PK\' THEN \'主键\' WHEN \'F\' THEN \'外键\' WHEN \'C\' THEN \'约束\' WHEN \'V\' THEN \'视图\'WHEN \'FN\' THEN \'函数-标量\' WHEN \'IF\' THEN \'函数-内嵌\' WHEN \'TF\' THEN \'函数-表值\'ELSE \'存储过程\' END DESC