SQL Server/T-SQL Tutorial/System Tables Views/sys.indexes

Query sys.indexes

5> SELECT top 10 name "Type name", type_desc "Type description", is_primary_key
6> FROM sys.indexes
7> GO
Type name                                                                                                                        Type description                                             is_primary
_key
-------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------ ----------
----
clust                                                                                                                            CLUSTERED
   0
clust                                                                                                                            CLUSTERED
   0
clust                                                                                                                            CLUSTERED
   0
NULL                                                                                                                             HEAP
   0
clust                                                                                                                            CLUSTERED
   0
clust                                                                                                                            CLUSTERED
   0
clst                                                                                                                             CLUSTERED
   0
clust                                                                                                                            CLUSTERED
   0
clst                                                                                                                             CLUSTERED
   0
nc1                                                                                                                              NONCLUSTERED
   0
(10 rows affected)