base_saveDDL
Save DDL definitions for Teradata tables, views, or stored procedures as .sql files on disk. Specify database, object name, type, and output directory.
Instructions
Extract the DDL for a Teradata table, view, or stored procedure and SAVE it as a .sql file on disk. Use this tool ONLY when the user explicitly wants to export, write, download, or persist DDL to a file. Do NOT use simply to display or view DDL in the conversation — use base_tableDDL to display DDL without saving.
Arguments: database_name - Database name (e.g., 'MKTG_USR') table_name - Object name (e.g., 'SP_LOAD_VARIABLES_ARGUMENTARIO_IAG_FICHA_CLIENTE'). Accepts comma-separated values for bulk retrieval. 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 |
|---|---|---|---|
| output_dir | No | ./ddls_extracted | |
| table_name | Yes | ||
| object_type | No | PROCEDURE | |
| database_name | Yes |