允许(一次)在数据库项目中删除列 [英] Allow (once) column drop in database project

问题描述

我想在现有表中删除一列.当我简单地从表的创建脚本中删除它时，它将在部署时导致错误(数据丢失...).我想允许(在这种情况下)列删除.你会怎么做?

I would like to drop one column in existing table. When I simply remove it from table's create script it will cause error (data loss...) on deployment. I would like to allow (in this case) column drop. How you would do that?

推荐答案

要禁用数据丢失错误:

1. 单击架构比较文件中的选项"图标.
2. 取消选中阻止可能的数据丢失".

该设置将仅针对1个模式比较进行更改，并且将保存在模式比较文件中.如果您只想执行一次，那么在删除该列后，您需要重新启用该选项.

The setting will change for just that 1 schema comparison and it will be saved within the schema comparison file. If you only want to do this once then you'll need to re-enable the option after you drop the column.

这篇关于允许(一次)在数据库项目中删除列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！