Compare database objects

Tools & Utilities
Enthusiast

Compare database objects

Hello,

Could someone please let me know how to compare the database objects using Teradata SQL Assistant just like we do in toad. I am trying to compare the tables existing in two different schemas(so called databases).

Thanks,
Suma.
2 REPLIES
Enthusiast

Re: Compare database objects

if you are bothered about verifying just column names and it's attributes, you can do it using a self join of DBC.Columns view.
Enthusiast

Re: Compare database objects

Thanks! That worked.

Suma