Total Page Preview:   000000001247

How to enable table re-creation in sql server

In this article I am going to explain how to Enable table Re-Creation in SQL Server using wizard

Saving changes not permitted. The changes you have made require the following tables to be dropped and re-create.You have either made changes to a table that can't be re-create or enabled the option pro=event saving changes that require the table to be re-created.

Step 1 : Open and login into SQL Server Management Studio.

Step 2 : After login successfully Go Manu bar:

 Tools >Options > Designers> Table or Database Designers

 

Table Re-Creation in SQL Server
 
Table Re-Creation in SQL Server
 
By : Brijesh Kumar
Thanks

 

Thank You

About Author

Brijesh Kumar

Database Developer

I have more then 6 years Experience in Microsoft Technologies - SQL Server Database, ETL Azure Cloud - Azure SQL Database, CosmosDB, Azure Data Factory, PowerBI, Web Job, Azure Function, Azure Storage, Web Apps, Powershall and Database Migration On-Premise to Azure Cloud.
LinkedIn : https://www.linkedin.com



Comments


                           
                           

                           

                           

Facebook User: