Rename Tables | Command Line | Teradata DSA - 17.20 - Renaming Tables - BAR - Data Stream Architecture

Teradata® DSA User Guide

Product
BAR
Data Stream Architecture
Release Number
17.20
Published
November 2022
Last Update
2022-11-14
Content Type
User Guide
Publication ID
B035-3150-101K
Language
English (United States)
Last Update
2022-11-14
You can rename tables in a restore job by adding rename_to to the table in the XML file containing the job definition.
  1. Open the XML file containing the job definition information.
  2. Under objectinfo, identify the table to rename and add the new table name inside rename_to.
    In the following example, table T1 in the ABC database is restored and renamed as T2:
    <objectinfo>
        <object_name>T1</object_name>
        <object_type>TABLE</object_type>
        <parent_name>ABC</parent_name>
        <parent_type>DATABASE</parent_type>
        <object_attribute_list>
            <rename_to>T2</rename_to>
        </object_attribute_list>
    </objectinfo>