“验证警告”对话框 (Visual Database Tools)Validation Warnings Dialog Box (Visual Database Tools)

适用于:Applies to: 是SQL ServerSQL Server(所有支持的版本)yesSQL ServerSQL Server (all supported versions) 是Azure SQL 数据库Azure SQL DatabaseYesAzure SQL 数据库Azure SQL Database 是Azure SQL 托管实例Azure SQL Managed InstanceYesAzure SQL 托管实例Azure SQL Managed Instance 是Azure Synapse AnalyticsAzure Synapse AnalyticsyesAzure Synapse AnalyticsAzure Synapse Analytics 是并行数据仓库Parallel Data Warehouseyes并行数据仓库Parallel Data Warehouse适用于:Applies to: 是SQL ServerSQL Server(所有支持的版本)yesSQL ServerSQL Server (all supported versions) 是Azure SQL 数据库Azure SQL DatabaseYesAzure SQL 数据库Azure SQL Database 是Azure SQL 托管实例Azure SQL Managed InstanceYesAzure SQL 托管实例Azure SQL Managed Instance 是Azure Synapse AnalyticsAzure Synapse AnalyticsyesAzure Synapse AnalyticsAzure Synapse Analytics 是并行数据仓库Parallel Data Warehouseyes并行数据仓库Parallel Data Warehouse

如果尝试保存的修改具有潜在的破坏性副作用,或者数据库提交操作很可能会失败,则会显示此对话框。This dialog box appears if you attempt to save modifications with potentially damaging side effects, or if the database commit operation is likely to fail. 此对话框可指示这些副作用可能会是什么或提交操作可能失败的原因。This dialog box indicates what those side effects might be or why the commit operation might fail. 使用此对话框可以选择继续修改还是取消操作。It gives you the chance to continue with the modification or cancel the operation.

备注

在尝试将修改传输到数据库或保存更改脚本时,将显示此对话框。This dialog box appears when you attempt to transmit your modifications to the database or when you save a change script.

以下任一原因都可能导致显示该对话框:The dialog box can appear for any of these reasons:

  • 您可能没有提交所有修改的数据库权限。You might not have database permissions to commit all the modifications.

  • 您的修改将导致生成格式不正确的派生列、默认约束或 CHECK 约束。Your modifications would result in improperly formed derived columns, default constraints, or check constraints.

  • 对列数据类型的修改可能导致数据丢失。A modification to a column's data type might cause data loss.

  • 修改可能导致索引大于 900 字节。A modification would result in an index greater than 900 bytes.

  • 修改将更改分配给绑定到架构的视图或用户定义函数的表或列。A modification would change a table or column contributing to a schema-bound view or user-defined function.

  • 修改将导致重新创建具有一个或多个加密触发器的表;这些触发器将被删除。A modification would result in the re-creation of a table that has one or more encrypted triggers; the triggers will be dropped.

  • 所做的修改将导致对一个表中的列的 ANSI_NULLS 或 ANSI_PADDING 选项进行重要设置,或同时对这两个选项进行设置。Your modifications will yield noteworthy settings of ANSI_NULLS or ANSI_PADDING or both for the columns within one table.

选项Options

Yes
继续操作以生成更改脚本或将修改传输到数据库。Proceed with the operation and generate the change script or transmit the modifications to the database. 提交操作在以下情况仍然会失败:您没有修改数据库的权限;所做的修改会导致索引大于 900 字节;或者修改会导致生成格式不正确的计算列、默认约束或 CHECK 约束。The commit operation can still fail if you do not have privileges to modify the database, if your modifications will result in an index greater than 900 bytes, or if your modifications will result in an improperly formed computed column, default constraint, or check constraint.

No
取消保存操作。Cancel the save action.

保存文本文件Save Text File
显示“另存为”**** 对话框,可以在其中为包含警告列表的文本文件指定位置。Display the Save As dialog box, where you can specify a location for a text file containing a list of the warnings.

另请参阅See Also

设计表 (Visual Database Tools)Design Tables (Visual Database Tools)
设计查询和视图操作指南主题 (Visual Database Tools)Design Queries and Views How-to Topics (Visual Database Tools)