Compare Table Objects in Teradata | Teradata Studio - Comparing Table Objects in Teradata - Teradata Studio

Teradata® Studio™ User Guide

Product
Teradata Studio
Release Number
17.00
Published
January 2021
Language
English (United States)
Last Update
2021-01-11
dita:mapPath
lex1576517377362.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2041
lifecycle
previous
Product Category
Teradata Tools and Utilities
  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 > "" .
  3. Select a profile from the Select Connection Profile list.
  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.

    Object DDL text comparison results