Compare Objects | Teradata Studio - Compare Objects - 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
The Compare SQL Objects wizard is associated with the Query Development perspective but is available in the Data Source Explorer view.

If you selected a database, user or table object to compare, and it has dependent objects you want to include in the comparison, select these objects in the Compare Objects screen. If an object has no dependent objects, the screen displays as blank.

Including dependent objects is an optional step. By default, the Compare SQL Objects wizard compares only the object you select with the referenced object.

Dependent Objects

You can include dependent objects in the comparison of database, user, and table objects. The Compare SQL Objects wizard gives you the option to include child databases and users, functions, hash and join indexes, macros, stored procedures, tables, triggers, and views. If you are comparing tables, you can include dependent triggers in the DDL comparison.