SQL Server 查看一個表上的索引

標籤：blog   http   ar   for   sp   2014   on   log   bs   

方法：1

      sys.indexes

      index_id =0:堆

      index_id =1:叢集索引

      index_id =2.....:非叢集索引

-------------------------------------------------------------------------------------

例子：

create table Student(
ID int not null,
Name nvarchar(16),
Major nvarchar(16));
go

create index ix_for_Student_ID
on dbo.student(ID);
go

create clustered index ix_clu_for_Student_Name
on dbo.Student(Name);
go

select OBJECT_NAME(ix.object_id),ix.index_id,ix.name from sys.indexes as ix
where ix.object_id = object_id(‘Student‘);
go

   

 

SQL Server 查看一個表上的索引