A single table indexes SQL Server

Asked Nov 20 '15 at 11:48

Active Dec 22 '15 at 06:05

Viewed 544 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

42,561
8
45
63

asked Nov 20 '15 at 11:48

user3624303

91
10

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,470
1
24
29

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