Table Compare

MilesGibsonMilesGibson Posts: 4
edited February 9, 2009 10:15AM in SQL Compare Previous Versions
Is there a way to do a table compare/synch within the same database? I have a table with a lengthy structure that I would like to synch to another table. Ideas? I could generate an update script etc, but I thought this would be easier...

TIA,
Best Regards,

Miles

Comments

  • Miles,
    my instant action on this would be to run:
    SELECT * INTO <table2> from <table1> where 1=2

    to my knowledge (and experience) this creates an identical, empty table in the same database.

    If you have SQL Prompt then you could create a snippet for it ...

    Senior DBA
    Careers South West Ltd
Sign In or Register to comment.