GET api/DatabaseSchema/Tables/{tableName}

Request Information

URI Parameters

Name	Description	Type	Additional information
tableName		string	Required

Body Parameters

None.

Response Information

Resource Description

Table

Name	Type	Additional information
ObjectId	integer	None.
Name	string	None.
Schema	string	None.
Owner	string	None.
LastUpdated	date	None.
Columns	Collection of Column	None.
Indexes	Collection of Index	None.
Triggers	Collection of Trigger	None.

Response Formats

application/json, text/json

Sample:

{
  "ObjectId": 1,
  "Name": "sample string 2",
  "Schema": "sample string 3",
  "Owner": "sample string 4",
  "LastUpdated": "2026-06-05T19:42:55.6577467-04:00",
  "Columns": {
    "$id": "2",
    "$values": [
      {
        "$id": "3",
        "$type": "WebPortalRTFAPI.Models.Schema.Column, WebPortalRTFAPI",
        "IsIdentity": true,
        "Name": "sample string 2",
        "DataType": "sample string 3",
        "MaxLength": 4
      },
      {
        "$ref": "3"
      }
    ]
  },
  "Indexes": {
    "$id": "4",
    "$values": [
      {
        "$id": "5",
        "$type": "WebPortalRTFAPI.Models.Schema.Index, WebPortalRTFAPI",
        "Name": "sample string 1",
        "IndexId": 2,
        "IsPrimary": true,
        "Columns": {
          "$id": "6",
          "$values": [
            {
              "$id": "7",
              "$type": "WebPortalRTFAPI.Models.Schema.IndexColumn, WebPortalRTFAPI",
              "Name": "sample string 1",
              "IsDescending": true
            },
            {
              "$ref": "7"
            }
          ]
        }
      },
      {
        "$ref": "5"
      }
    ]
  },
  "Triggers": {
    "$id": "8",
    "$values": [
      {
        "$id": "9",
        "$type": "WebPortalRTFAPI.Models.Schema.Trigger, WebPortalRTFAPI",
        "ObjectId": 1,
        "Name": "sample string 2",
        "LastUpdated": "2026-06-05T19:42:55.6577467-04:00",
        "Definition": "sample string 4"
      },
      {
        "$ref": "9"
      }
    ]
  }
}