Describe table schema
db_describe_tableRetrieve the column structure of an Oracle table, including data types, lengths, nullable flag, and default values, to understand its schema before writing queries.
Instructions
Get the column structure of a specific Oracle table: column names, data types, data lengths, nullable flag, and default values.
Use this after db_list_tables to understand a table's schema before writing queries.
Args:
table_name (string): The table name to inspect (case-insensitive)
owner (string, optional): Schema/owner name for cross-schema access
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"table_name": "<table_name>"
},
"name": "db_describe_table"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| owner | No | Optional: schema/owner of the table (case-insensitive). Use when the table is in another schema. | |
| table_name | Yes | Name of the table to describe (e.g., 'users', 'orders'). Case-insensitive — will be uppercased. |