Apache Derby · JSON Structure

Apache Derby Table Info Structure

Metadata about a table in an Apache Derby database, as returned by JDBC DatabaseMetaData.getTables().

Type: object Properties: 5 Required: 2
ApacheDatabaseEmbeddedJavaJDBCOpen SourceRelationalSQL

TableInfo is a JSON Structure definition published by Apache Derby, describing 5 properties, of which 2 are required. It conforms to the https://json-structure.org/meta/core/v0/# meta-schema.

Properties

tableName tableSchema tableCatalog tableType remarks

Meta-schema: https://json-structure.org/meta/core/v0/#

JSON Structure

apache-derby-table-info-structure.json Raw ↑ 
{
  "$schema": "https://json-structure.org/meta/core/v0/#",
  "$id": "https://raw.githubusercontent.com/api-evangelist/apache-derby/refs/heads/main/json-structure/apache-derby-table-info-structure.json",
  "name": "TableInfo",
  "description": "Metadata about a table in an Apache Derby database, as returned by JDBC DatabaseMetaData.getTables().",
  "type": "object",
  "properties": {
    "tableName": {
      "type": "string",
      "description": "Name of the table.",
      "example": "EMPLOYEES"
    },
    "tableSchema": {
      "type": "string",
      "description": "Schema (owner) of the table.",
      "example": "APP"
    },
    "tableCatalog": {
      "type": "string",
      "description": "Catalog of the table (always null in Derby).",
      "example": null
    },
    "tableType": {
      "type": "string",
      "description": "Type of table object.",
      "enum": [
        "TABLE",
        "VIEW",
        "SYSTEM TABLE",
        "SYNONYM"
      ],
      "example": "TABLE"
    },
    "remarks": {
      "type": "string",
      "description": "Table comment if defined.",
      "example": "Employee records table"
    }
  },
  "required": [
    "tableName",
    "tableType"
  ]
}