查找没有聚集索引但在表上有主键的表 [英] Find Tables Without Clustered Index but with Primary Keys on a table

问题描述

是否有脚本可以查找没有聚集索引的表，但上面有 Sql server 2008 r2 的主键?请告诉我.

Is there an script to find Tables with no Clustered Indexes, but has Primary Keys on it for Sql server 2008 r2? Please let me know.

推荐答案

是这样的:

SELECT
            so.name AS TableName,
            si.name AS IndexName,
            si.type_desc AS IndexType,
            si.is_primary_key
FROM
            sys.indexes si
            JOIN sys.tables so ON si.[object_id] = so.[object_id]
WHERE
            si.type IN (0, 2)
            AND si.is_primary_key=1
ORDER BY
            so.name

这篇关于查找没有聚集索引但在表上有主键的表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！