Table Compare

MilesGibson

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,

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 ...