Save Changes without Dropping and Re-Creating Table in visual studio 
In Visual Studio when you are dealing with tables in Server Explorer, once you create a table and then you need to change any value in the table data, you will probably get the following error.
To solve this error or to edit the table data after the table creation follow the simple steps.
Go-to Tools > Options
Go-to Tools > Options
.png "visual studio tools options")
Expand Database Tools
.png "visual studio options")
Click Table and Database Designers
.png "visual studio table and database designers")
Uncheck Prevent saving changes that require table re-creation
.png "visual studio table and database")
Click OK apply the changes
