Compare database objects

Tools
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