alter table add column SQL | saving changes is not permitted sql | Solved 100%
sql add column:
How do you add a new column in SQL without dropping a table?
When I try to edit the table design, like change a column type from int to real,or adding a new column to the table, I get this error:
Saving changes is not permitted. The change you have made requires the following table to be dropped and re-created. You have either made changes to a table that can't be recreated or enabled the option prevent saving changes that require the table to be re-created.
Solution:
if you use the SQL server management studio, then:
1. Open Microsoft SQL Server Management Studio
2. Click Tools menu options, then click Options
3. Select Designers
4. Uncheck "prevent saving changes that require table re-creation" option
5. Click OK
For more detail watch the video.
Javed Ikram
Hafeez Computers Thakot
Computer Problems and their solutions
#SQL
#Programming
.........................................More Videos ...................
sql date conversion | Convert Date format into DD/MM/YYYY format in SQL
• sql date conversion | Convert Date format ...
An error occurred When attaching the database | MDF file Cannot attach SQL • An error occurred When attaching the datab...
could not load file or assembly | Microsoft Report Viewer SQL Server • could not load file or assembly | Microsof...