Introduction
In this article you will learn how to resolve “Saving changes is not permitted” in SQL. The following table “Table_1” contain the student mark information. I want to change that column name “Subject” to “Mark”.
Step 1: I have one table “Table_1” and it contain the student mark information.
Step 2: Design View of “Table_1”.
Step 3: Now I changed the “Subject” name as “Mark” and “varchar(50)” as “int”. It is throwing the exception “Saving changes is not permitted”.
Step 4: Go to Tools, click Options…, Expand Designers, then click Table and Database Designers,
Step 5: Remove checked in “Prevent saving changes that require table re-creation.” Click Ok.
Step 6: Click OK,
Step 7: Output,
Summary
We learned how to resolve “Saving changes is not permitted” in SQL. I hope this article will be useful for beginners.