If you've dealt with MS SQL before, by default, it does not allow you to modify a table without you dropping it and recreating it. It's kind of annoying. Here's a way to get around it. Do this at your own risk of corrupting your database.
-Go to the Tools menu -> Options
-Click on "Designers" on the left menu tree
-Uncheck "Prevent saving changes that require table re-creation"
No comments:
Post a Comment
Thank you for your comment.