Search code examples
sql-servervisual-studiosql-server-data-tools

vs2015 ssdt : publish could not drop table from db (deleted from package)

I am successful to add create a table in SSDT project and publish to DB. The Publish could not drop that table from database when it has been deleted from project.

enter image description here

Even 'Drop objects in terget but not in project' checked in project\Properties\Debug\Deployment options.

However, it is working when upgrading the database from the .dacpac (in review the upgrade plan).

enter image description here

Could not find 'Drop objects in terget but not in project' in project\My Advanced Publish Settings:

enter image description here

Any idea please?

Solution

  • It is in tab Drop of Publish\Advanced

    enter image description here