Save Changes without Dropping and Re-Creating Table in visual studio
visual studio server explorer table
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.
visual studio edit table error
To solve this error or to edit the table data after the table creation follow the simple steps.

Go-to Tools > Options
visual studio tools options
Expand Database Tools
visual studio options
Click Table and Database Designers
visual studio table and database designers
Uncheck Prevent saving changes that require table re-creation
visual studio table and database
Click OK apply the changes




TechCybo

TechCybo

A Technolgy Blog about How-To Tutorials, Android, Programming, Blogging, Windows, Software Tips, Mobile Apps and Tricks for better Digital Life

Post A Comment: