base_saveDDL
Extract and save the full DDL of a Teradata object (table, view, procedure) to a .sql file directly on the server, avoiding token limit issues when passing large DDL content through responses.
Instructions
Extracts the complete DDL of a Teradata object and saves it to a .sql file.
This tool solves the token limit problem by executing the extraction and file save operation directly on the server side, without needing to pass large DDL content through the response.
Arguments: database_name - Database name (e.g., 'MKTG_USR') object_name - Object name (e.g., 'SP_LOAD_VARIABLES_ARGUMENTARIO_IAG_FICHA_CLIENTE') object_type - Type of object: 'PROCEDURE', 'TABLE', 'VIEW' (default: 'PROCEDURE') output_dir - Directory where to save the DDL file (default: './ddls_extracted')
Returns: ResponseType: formatted response with file path, size, and metadata
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| database_name | Yes | ||
| object_name | Yes | ||
| object_type | No | PROCEDURE | |
| output_dir | No | ./ddls_extracted |