Mega Code Archive

 

Categories / MSSQL Tutorial / System Tables Views

 

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)