How To Resolve “Saving Changes is Not Permitted” Error In SQL

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,

 

 

 

Tech Blog Reference: Reference

Summary

We learned how to resolve “Saving changes is not permitted” in SQL. I hope this article will be useful for beginners.