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

Teradata® Data Mover User Guide

Product
Teradata Data Mover
Release Number
17.10
Published
June 2021
Language
English (United States)
Last Update
2021-06-16
dita:mapPath
fcu1619423186706.ditamap
dita:ditavalPath
mpm1591127278842.ditaval
dita:id
B035-4101
lifecycle
previous
Product Category
Analytical Ecosystem
  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>