A single table indexes SQL Server

Asked Nov 20 '15 at 11:48

Active Dec 22 '15 at 06:05

Viewed 437 times

1

How to view the indexes of a single table, not all tables, in SQL Server 2014?

edited Nov 20 '15 at 11:58

jarlh

40,041
8
39
58

asked Nov 20 '15 at 11:48

user3624303

91
9

1 Answers1

1

You can use SP_INDEXES or sp_helpindex

EXEC sp_indexes 'table name'

or

EXEC sp_helpindex 'table name'

edited Dec 22 '15 at 06:05

answered Nov 20 '15 at 11:50

Madhivanan

13,244
1
23
28

empty set is returned – user3624303 Nov 20 '15 at 12:27
It means that the table has no indices – Madhivanan Dec 22 '15 at 06:05