|
|
Archives of the TeradataForum
Message Posted: Mon, 17 Dec 2007 @ 13:59:59 GMT
Subj: | | Re: Verifying tables structures between two different databases |
|
From: | | Koppusetty, Suresh |
Vinay - I am trying to compare between two databases on the same server, currently I am using the following sql which
Select databasename, tablename
From dbc.TABLES
Where databasename = 'db_a'
Minus
Select Databasename, tablename
From dbc.TABLES
Where databasename = 'db_b'
uses "MINUS"" function, to get the difference of tables between 2 databases.
But is there anyway without using minus function, can we get the output.
Thanks
Suresh
| |