>I have been learning SQL 2008. After creating a few related tables, I added a few additional column to one of the tables. When I attempt to save the table structure I get an error telling me that the table can not be dropped and re-created.
>
>1. Why when added a new column does SQL need to drop the original and re-create it?
>
>2. If the constraint are the problem, why doesn't SQL drop the constraints and recreate them?
Greg,
Check out Message #
1469338 and also read Sergey's warning in the same thread.
"The five senses obstruct or deform the apprehension of reality."
Jorge L. Borges?
"Premature optimization is the root of all evil in programming."
Donald Knuth, repeating C. A. R. Hoare
"To die for a religion is easier than to live it absolutely"
Jorge L. Borges