SQL Table Structure Comparisons 1

[oneworld]

I am new to SQL server. Is there a quick and simple way to compare the structure of two tables on the same SQL server and also on two different SQL servers?

Oneworld

 

[JayKusch]

SQL Compare by Red Gate Software is indespencable for work like this.

http://www.red-date.com

Thanks

J. Kusch

 

[nigelrivett]

Easiest way is to script them and use sourcesafe.
If you need to do this it probably means you have an uncontrolled environment. I would suggest implementing something like this

http://www.nigelrivett.net/DMOScriptAllDatabases.html

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.