This is because the script generated would contain a DROP TABLE statement. Of course it would have saved everything in a temp table before being dropped and re-created the table so nothing would have actually been lost.
Even still, it is probably a nice little safe guard for those who maybe aren't that used to SQL Server but I am so: how to get round it?
Solution
If you are confident that you are a legend with your SQL skills and you just want to be left alone you can disable this warning.Go Tools » Options...
Go Designers » Table and Database Designers and then uncheck "Prevent saving changes that require table re-creation"
Job done - enjoy at your peril!
This is an awesome post. Really very informative and creative contents. This concept is a good way to enhance the knowledge. I like it and help me to development very well. Thank you for this brief explanation and very nice information. Well, got a good knowledge.
ReplyDeleteSEO Course in Chennai