how to compare tables data

		Wrox Programmer Forums > Database > SQL Language
how to compare tables data

SQL Language SQL Language discussions not specific to a particular RDBMS program or vendor.

Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Language section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com

April 10th, 2006, 04:38 AM

ramanadyv

Authorized User

Join Date: Jan 2006

Posts: 14

Thanks: 0

Thanked 0 Times in 0 Posts

how to compare tables data

I have one table called A in two different data-schemas.
Now, i need to compare whether the column_names,data_type and data_length are equal in two data-schemas or not.
How , i can do that?
Give me any suggestions ASAP...

Regards,
Venkat.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Compare 2 tables in 2 different DBs	Feodorov	SQL Server 2005	4	March 7th, 2008 08:08 AM
Compare two fields from different tables	pallone	SQL Server 2000	10	March 23rd, 2007 05:14 PM
Compare records between two tables	jaaboston	Access VBA	1	December 21st, 2006 05:35 AM
Compare 2 tables....	Seb_soum	Classic ASP Databases	2	June 4th, 2004 05:47 PM