How can we help you today? How can we help you today?

Table Compare

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,
MilesGibson
0

Comments

1 comment

Sort by
  • fatherjack2
    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 ...
    fatherjack2
    0

Add comment

Please sign in to leave a comment.