Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Change DB Structure with FOREIGN KEY constraint
Message
 
 
To
07/07/2010 10:38:23
General information
Forum:
Microsoft SQL Server
Category:
Scripting
Environment versions
SQL Server:
SQL Server 2008
Miscellaneous
Thread ID:
01471590
Message ID:
01471686
Views:
26
>I check and all of you are correct. The data is preserved after the re-creation. Funny, none of the documentation I found attempt to clarify that point. The statement on the checkbox led me to beleive it would not preserve the data.
>
The option may be a bit confusing, but from the common sense, why would SQL Server dump data? This will be considered a major bug then.
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform