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 …

Make changes to SQL Server without dropping and recreating table Read more »