Rename Child Database Tables | Teradata Data Mover - 17.10 - Renaming Tables in a Child Database - Teradata Data Mover

Teradata® Data Mover User Guide

Product
Teradata Data Mover
Release Number
17.10
Release Date
June 2021
Content Type
User Guide
Publication ID
B035-4101-061K
Language
English (United States)
  1. Add the selection="included" attribute to the table element.
  2. Specify the name of the source table.
  3. Specify the renamed target table with the target_name element.
In the following example, MyDatabase and all its children are copied to the target, but the MyDatabase_child.ORDERS table is renamed to MyDatabase_child.ORDERS_NEWNAME on the target.
<database selection="all"> 
<name>MyDatabase</name> 
	<database selection="included"> 
	<name>MyDatabase_child</name> 
		<table selection="included"> 
			<name>ORDERS</name> 
			<target_name>ORDERS_NEWNAME</target_name> 
		</table> 
 </database> 
</database>