base_saveDDL
Extracts complete DDL of a Teradata object and saves it to a .sql file directly on the server, avoiding token limit issues.
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 |