Deploy SSDT database project: update table with security policy fails when column was added
During publishing of a SSDT Database Project, after adding a column on a table with an view and a security policy on Azure SQL Database, deployment fails with this error message:
(51,1): SQL72014: .Net SqlClient Data Provider: Msg 3729, Level 16, State 3, Procedure vDemo, Line 1 Cannot ALTER 'dbo.vDemo' because it is being referenced by object 'SecurityPolicy_Demo'.
(51,0): SQL72045: Script execution error. The executed script:
ALTER VIEW [dbo].[vDemo]