Question

求sql语句：提取某个数据库中所有表的索引名

Answer 1

用sys.indexes直接提取不好吗？
SELECT
OBJECT_SCHEMA_NAME(object_id)+'.'+OBJECT_NAME(object_id)
AS
表名,name
AS
索引名
FROM
sys.indexes
WHERE
index_id<>0
AND
object_id
IN(SELECT
object_id
FROM
sys.tables)