compare 2 tables in the same db

gsuttiegsuttie Posts: 80
edited September 28, 2009 11:05AM in SQL Compare Previous Versions
Hi There

If I have t_user and I make a copy of this table scalled t_user_copy without any of the original constraints - how can i compare t_user and t_user_copy within the same db?

Thanks
G

Comments

  • Brian DonahueBrian Donahue Posts: 6,590 New member
    Thanks for your question. SQL Compare currently will not work to compare two differently-named tables in the same database. You would have to clone the tables into a second database and compare the two databases.
Sign In or Register to comment.