How to Edit and Save Database Table Data without Dropping and Re-Creating Table in visual studio

0
235
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


LEAVE A REPLY

Please enter your comment!
Please enter your name here