gistfile1.txt

SQL> SELECT name, type_desc, is_unique, is_primary_key FROM sys.indexes WHERE [object_id] = OBJECT_ID('dbo.reguser');
+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------------------------------------------------------------------------------------------------+----------+---------------+
| name                                                                                                                                                                                                                                                           | type_desc                                                                                                               | is_unique| is_primary_key|
+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------------------------------------------------------------------------------------------------+----------+---------------+
|                                                                                                                                                                                                                                                                | HEAP                                                                                                                    | 0        | 0             |
| PK_reguser                                                                                                                                                                                                                                                     | NONCLUSTERED                                                                                                            | 1        | 1             |
| AK_reguser                                                                                                                                                                                                                                                     | NONCLUSTERED                                                                                                            | 1        | 0             |
| ie_reguser_idx1                                                                                                                                                                                                                                                | NONCLUSTERED                                                                                                            | 0        | 0             |
| ak_reguser_idx_1                                                                                                                                                                                                                                               | NONCLUSTERED                                                                                                            | 1        | 0             |
+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------------------------------------------------------------------------------------------------+----------+---------------+
SQLRowCount returns 5
5 rows fetched
SQL>