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
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. |