GET api/DatabaseSchema/Tables

Request Information

URI Parameters

None.

Body Parameters

None.

Response Information

Resource Description

Collection of 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:

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