There are some tools out there to help you with that task. I really like
http://www.red-gate.com/products/SQL_Compare/index.htm. I just can't live without it.
>Hi everybody,
>
>I have a table with data. I also have a CREATE table script for this table. What should be the best way to proceed to find if the structure has really changed?
>
>I guess I can scipt my existing table and then compare two scripts, but is there another way?
>
>Thanks a lot in advance.
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com