visual studio database project - publish did not include drops but schema compare did I just observed a difference in the result of publish vs schema compare.  I made changes to visual studio database project - some of which involved deleting tables.


Pushed changes to VSTS, build successful, release successful to Azure DB
Inspected said Azure DB.  Tables were not dropped that were deleted in the project.  Double checked the publish script - this didn't include any of the drops.
Ran SchemaCompare - this exposed all of the missing drops, and when executed gave me the result I expected (the applicable tables were dropped).


The same results were observed on local DB when manually publishing vs schema compare.  What am I doing incorrectly?  I thought publish would drop the tables.
Publish>Advanced Settings>Drop>"Drop objects in target but not in source"

https://stackoverflow.com/questions/1799802/dropping-a-table-with-visual-studio-2010-database-project