All Forums Tools
30 Apr 2007
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.

joedsilva 505 posts Joined 07/05
01 May 2007

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.

01 May 2007

Thanks! That worked.Suma

You must sign in to leave a comment.