Make changes to SQL Server without dropping and recreating table
Allowing SQL Server to accept changes to tables through the designer is not recommended. Use Transact-SQL statements to make the changes to the metadata structure of a table.
I you must:
To change the Prevent saving changes that require the table re-creation option, follow these steps:
- Open SQL Server Management Studio (SSMS).
- On the Tools menu, click Options.
- In the navigation pane of the Options window, click Designers.
- Select or clear the Prevent saving changes that require the table re-creation check box, and then click OK.
David Gregory Medina
Post created by: David Gregory Medina