halopsa_table_info
Retrieve table structure details including columns, data types, nullable fields, and relationships to understand HaloPSA database schema for effective query planning.
Instructions
Get detailed information about a specific HaloPSA table including all columns, data types, nullable fields, and relationship suggestions. Use this to understand table structure before writing queries.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| tableName | Yes | Name of the table to inspect. Example: FAULTS, USERS, SITE, ACTIONS, REQUESTTYPE |
Input Schema (JSON Schema)
{
"properties": {
"tableName": {
"description": "Name of the table to inspect. Example: FAULTS, USERS, SITE, ACTIONS, REQUESTTYPE",
"type": "string"
}
},
"required": [
"tableName"
],
"type": "object"
}