Visual Studio 2013数据库项目 - 目标中的DROP对象，但不在项目中 [英] Visual Studio 2013 database project- DROP objects in target but not in project

问题描述

我使用VS 2013的数据库项目。我想从目标数据库删除不在db项目包括表和SP的。我已经检查属性DROP对象在目标，但不是在项目，但它不工作。我仍然看到目标中的表，它不是db解决方案的一部分。我没有看到任何警告，并且btw表是空的，所以它应该被丢弃，无论如何没有警告。我在早期版本的Visual Studio中使用相同的选项，它的工作。
任何建议？

I am using VS 2013 for database project. I want to drop ojected from target db which are not in db project including table and SP's. I have checked property "DROP objects in target but not in project" but it doesn't work. I still see table in target which is not part of db solution. I do not see any warnings either and btw table is empty so it should be dropped without warnings anyway. I have used same option in older version of Visual studio and it worked. Any suggestions?

推荐答案

我知道这是很长时间来回答这个问题，解决了问题。我只需打开SQL文件TableName.sql

I know this is a long time coming to answer the question, but this is how I resolved the problem. I simply opened the SQL File TableName.sql

1. Ctrl + a（aka全选）








5. Visual Studio 2013项目中的文件

1. Ctrl+a (aka select all)
2. Compare
3. It will show the file with an action to delete in the compare
4. Update
5. Delete the file from Visual Studio 2013 project

这篇关于Visual Studio 2013数据库项目 - 目标中的DROP对象，但不在项目中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！