How to show INDEXES on Microsoft SQL Server / Azure SQL Database

To show the indexes on a Table, use the sp_helpindex:

EXEC sp_helpindex N'MyTableNameHere'

For example:

EXEC sp_helpindex N'dbo.CMS_Article'

This will produce a table with the INDEXES listed:

Remarks

If indexes have been set by using the NORECOMPUTE option of UPDATE STATISTICS, that information is included in the index_description column.

sp_helpindex exposes only orderable index columns; therefore, it does not expose information about XML indexes or spatial indexes.

See the Documentation:

sp_helpindex (Transact-SQL) - SQL Server | Microsoft Docs