Following errors occurred while updating an .mdf database, it was working fine but before editing the Column Names of few tables. (I am using Server Explorer of Visual Studio 2013.)
Update cannot proceed due to validation errors.
Please correct the following errors and try again.
SQL72015 :: The table [dbo].[Customer] is being dropped and re-created since all non-computed columns within the table have been redefined.
SQL72031 :: This deployment may encounter errors during execution because changes to [dbo].[Product].[ProductID] are blocked by [dbo].[Product]'s dependency in the target database.
SQL72031 :: This deployment may encounter errors during execution because changes to [dbo].[Transaction].[TransactionID] are blocked by [dbo].[Transaction]'s dependency in the target database.
SQL72031 :: This deployment may encounter errors during execution because changes to [dbo].[Purchase].[TransactionID] are blocked by [dbo].[Purchase]'s dependency in the target database.
SQL72031 :: This deployment may encounter errors during execution because changes to [dbo].[Sales].[TransactionID] are blocked by [dbo].[Sales]'s dependency in the target database.
Try this:
Go to Tools menu -> Options -> Database Tools -> Table and Database Designers ( -> Table and Diagram Options) -> Untick/Unselect Prevent saving changes that require table re-creation.
This is as of VS2010, but it should not be much different in VS2013.