如何查找SQL Server中特定索引的所有列?
答
以下示例返回表myTbl
的所有索引和索引列。
SELECT i.name AS index_name
,COL_NAME(ic.object_id,ic.column_id) AS column_name
,ic.index_column_id
,ic.key_ordinal
,ic.is_included_column
FROM sys.indexes AS i
INNER JOIN sys.index_columns AS ic
ON i.object_id = ic.object_id AND i.index_id = ic.index_id
WHERE i.object_id = OBJECT_ID('myTbl');
+0
你应该链接你的源... https://docs.microsoft.com/en-us/sql/relational-databases/system-catalog-views/sys-index-columns-transact-sql – scsimon
+0
@scsimon感谢您的突出。完成。 –
答
好了,你可以去那SSMS DB>表和脚本出来的指数下的索引文件夹以查看有关它的一切。或者,只需右键单击索引并单击“属性”,列将列在General
到目前为止您尝试过了哪些? – bated