儲存 (不允許) 對話方塊Save (Not Permitted) Dialog Box

適用於: 是SQL Server 是Azure SQL Database 是Azure Synapse Analytics (SQL DW) 是平行處理資料倉儲 APPLIES TO: yesSQL Server yesAzure SQL Database yesAzure Synapse Analytics (SQL DW) yesParallel Data Warehouse

[儲存] (不允許) 對話方塊會警告您不允許儲存變更,因為您所做的變更需要卸除及重新建立所列出的資料表。The Save (Not Permitted) dialog box warns you that saving changes is not permitted because the changes you have made require the listed tables to be dropped and re-created.

下列動作可能需要重新建立資料表:The following actions might require a table to be re-created:

  • 將新的資料行加入資料表的中間Adding a new column to the middle of the table

  • 卸除資料行Dropping a column

  • 變更資料行的 Null 屬性Changing column nullability

  • 變更資料行的順序Changing the order of the columns

  • 變更資料行的資料類型Changing the data type of a column

若要變更這個選項,請在 [工具] 功能表上按一下 [選項] ,展開 [設計工具] ,然後按一下 [資料表和資料庫設計工具] 。To change this option, on the Tools menu, click Options, expand Designers, and then click Table and Database Designers. 選取或清除 [防止儲存需要資料表重建的變更] 核取方塊。Select or clear the Prevent saving changes that require the table to be re-created check box.