How to find the type of indexes (PRIMARY/UNIQUE/FULL-TEXT/SPATIAL/NON-CLUSTERED/SHARD) created for the particular table



Can anyone help, how to know the type of indexes which were already created for the existing table, whether that is PRIMARY/UNIQUE/FULL-TEXT/SPATIAL/NON-CLUSTERED/SHARD.

When I am using INFORMATION_SCHEMA.STATISTICS table, I am able to see only 2 index_types i.e., BTREE,SHARD. Which ever index I will create the index_type showing as BTREE (storage structure).

Do we have any other information schema table/view to know these clear index information like in MSSQL DB.