API Documentation

Last Update: 28 December 2022

GET api/MSSQLDatabaseIndex



Request Information


URI Parameters

None.


Body Parameters

None.

Response Information


Resource Description
Collection of MSSQLDatabaseIndex
Name Description Type Additional information
ID

integer

None.

ReportDate

date

None.

DatabaseLocalID

integer

None.

HostID

integer

None.

DatabaseGuid

string

None.

TableID

integer

None.

TableName

string

None.

IndexID

integer

None.

Name

string

None.

IndexedColumns

string

None.

IndexType

string

None.

IsClustered

string

None.

IsMemoryOptimized

string

None.

IsFileTableDefined

string

None.

IsFullTextKey

string

None.

IsPartitioned

string

None.

IsSystemObject

string

None.

RecordStatus

integer

None.

Response Formats
application/json, text/json
Sample:
[
  {
    "$id": "1",
    "ID": 1,
    "ReportDate": "2024-02-23T05:27:05.9043955+01:00",
    "DatabaseLocalID": 3,
    "HostID": 4,
    "DatabaseGuid": "sample string 5",
    "TableID": 6,
    "TableName": "sample string 7",
    "IndexID": 8,
    "Name": "sample string 9",
    "IndexedColumns": "sample string 10",
    "IndexType": "sample string 11",
    "IsClustered": "sample string 12",
    "IsMemoryOptimized": "sample string 13",
    "IsFileTableDefined": "sample string 14",
    "IsFullTextKey": "sample string 15",
    "IsPartitioned": "sample string 16",
    "IsSystemObject": "sample string 17",
    "RecordStatus": 18
  },
  {
    "$ref": "1"
  }
]