All geek questions in one place

Changing the table structure in SQl Server 2008

I am trying to redesign a table in SQL Server 2008, but I am getting a message stating that I need to drop and recreate the table. How can I solve this problem.

Saving changes is not allowed. The changes you made require the following tables, which need to be discarded, and reassembled. You either made table changes that cannot be recreated, or the option to prevent changes that require a table to be recreated is enabled.

+3
source share
3 answers

Go to: Tools - Options - Designers - Designers of tables and databases and uncheck "Prevent saving changes that require re-creating the table"

+10

ALTER TABLE. , nullability, / , / ( ) .

GUI , IDENTITY.

0

As Pcofre said, the answer is: select Tools ---> Options ----> Designer ----> in the right pane, find the option value to prevent the tables from being recreated then uncheck

0
source

Source: https://habr.com/ru/post/1790772/

More articles:


All Articles