Comparing Table Objects in Teradata - Teradata Studio

Teradata Studio User Guide

Product
Teradata Studio
Release Number
15.12
Published
August 2016
Language
English (United States)
Last Update
2018-05-03
dita:mapPath
cev1468860002862.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2041
lifecycle
previous
Product Category
Teradata Tools and Utilities
You can compare the Data Definition Language (DDL) text of two Teradata table objects. You must be able to connect to the Teradata Databases where the objects are stored.
  1. Open the Data Source Explorer and navigate to the Table object you want to use for the comparison. This object is called the referenced object.
  2. Right-click the referenced object and select Teradata > Compare With.
  3. Select a profile from the Select Connection Profile list. The list shows Connection Profiles to which you are currently connected. If you do not see the profile you need, go to the Data Source Explorer and right-click Database Connections to connect to the correct profile.
  4. Use the expanded Database navigation tree to select the database that contains the table with which to compare. If you select a database that does not contain tables, the message "No Tables" displays below the database list.
  5. Select a table object from the Table list. This object is called the compared to object.
  6. Click Next to select additional objects to include in the comparison.
  7. Select additional objects you want to include in the comparison by checking the box beside it. If the table does not contain other objects such as triggers, the Compare Objects screen is blank.
  8. Click Finish. Results of the object DDL text comparison display in the Compare View.