halopsa_list_columns
Retrieve column details for any HaloPSA database table, including data types, lengths, and nullable status to understand table structure and plan queries effectively.
Instructions
List columns for a specific table in the HaloPSA database using information_schema.columns. Returns detailed column information including data types, max length, and nullable status.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| tableName | Yes | Table name to get columns for. Example: FAULTS, USERS, SITE | |
| columnFilter | No | Optional filter to search for specific column names. Example: "id", "name", "date" |
Input Schema (JSON Schema)
{
"properties": {
"columnFilter": {
"description": "Optional filter to search for specific column names. Example: \"id\", \"name\", \"date\"",
"type": "string"
},
"tableName": {
"description": "Table name to get columns for. Example: FAULTS, USERS, SITE",
"type": "string"
}
},
"required": [
"tableName"
],
"type": "object"
}