API Documentation

Last Update: 28 December 2022

GET api/MSSQLDatabaseTable



Request Information


URI Parameters

None.


Body Parameters

None.

Response Information


Resource Description
Collection of MSSQLDatabaseTable
Name Description Type Additional information
ID

integer

None.

ReportDate

date

None.

DatabaseLocalID

integer

None.

HostID

integer

None.

DatabaseGuid

string

None.

TableID

integer

None.

Name

string

None.

AnsiNullsStatus

string

None.

ChangeTrackingEnabled

string

None.

HasAfterTrigger

string

None.

HasClusteredColumnStoreIndex

string

None.

HasClusteredIndex

string

None.

HasCompressedPartitions

string

None.

HasDeleteTrigger

string

None.

HasIndex

string

None.

HasInsertTrigger

string

None.

HasInsteadOfTrigger

string

None.

HasUpdateTrigger

string

None.

Indexes

string

None.

IsFileTable

string

None.

IsIndexable

string

None.

IsMemoryOptimized

string

None.

IsPartitioned

string

None.

IsSchemaOwned

string

None.

Replicated

string

None.

TrackColumnsUpdatedEnabled

string

None.

CreateDate

date

None.

DateLastModified

date

None.

RecordStatus

integer

None.

Response Formats
application/json, text/json
Sample:
[
  {
    "$id": "1",
    "ID": 1,
    "ReportDate": "2024-11-21T06:29:03.2897054+00:00",
    "DatabaseLocalID": 3,
    "HostID": 4,
    "DatabaseGuid": "sample string 5",
    "TableID": 6,
    "Name": "sample string 7",
    "AnsiNullsStatus": "sample string 8",
    "ChangeTrackingEnabled": "sample string 9",
    "HasAfterTrigger": "sample string 10",
    "HasClusteredColumnStoreIndex": "sample string 11",
    "HasClusteredIndex": "sample string 12",
    "HasCompressedPartitions": "sample string 13",
    "HasDeleteTrigger": "sample string 14",
    "HasIndex": "sample string 15",
    "HasInsertTrigger": "sample string 16",
    "HasInsteadOfTrigger": "sample string 17",
    "HasUpdateTrigger": "sample string 18",
    "Indexes": "sample string 19",
    "IsFileTable": "sample string 20",
    "IsIndexable": "sample string 21",
    "IsMemoryOptimized": "sample string 22",
    "IsPartitioned": "sample string 23",
    "IsSchemaOwned": "sample string 24",
    "Replicated": "sample string 25",
    "TrackColumnsUpdatedEnabled": "sample string 26",
    "CreateDate": "2024-11-21T06:29:03.2897054+00:00",
    "DateLastModified": "2024-11-21T06:29:03.2897054+00:00",
    "RecordStatus": 29
  },
  {
    "$ref": "1"
  }
]