I created a table tbl_Candidate
, but I forgot to set the primary key to the table and I saved it without primary key.
Next time I'm going to set primary key in SQL Server 2008 Express, I get a message like I have to drop the table and recreate when I'm going to save the table with primary key changes.
This is the message that pops up when I'm trying to save changes in the table:
Saving changes is not permitted. The changes you have made require that the following tables to dropped and recreate. You have either made changes to the table that can't be recreate or enable the option prevent saving changes that require the tables to be recreate
I'm logged into SQL Server with Windows authentication, server type as database engine and Server name as .\SQLExpress
.
Please give me a way to correct this problem or way to change the settings of the SQL Server.