sp_helpindex
来查看特定表的索引信息:,,``sql,EXEC sp_helpindex 'your_table_name';,
`,,或者通过查询系统视图
sys.indexes 获取详细信息:,,
`sql,SELECT name AS IndexName, type_desc AS IndexType, is_unique AS IsUnique,FROM sys.indexes,WHERE object_id = OBJECT_ID('your_table_name');,
``