如果从一个带有10个索引的表删除一行，DB 2必须删除与被删除的行关联的所有索引条目。
Delete a row from a table with 10 indexes, and DB2 must remove all index entries associated with the deleted rows.
在创建或更新文档类型时，可以从文档类型选择需要添加或删除的属性表。
While creating or updating a document type, you can select property sheets to be added or removed from the document type.
因此，需要通过定期清理步骤表来删除不需要的条目。
Therefore, you should periodically prune the steps table to remove unwanted entries.
清单7演示了从指定的工作表删除最后一行的过程。
Listing 7 illustrates, by deleting the last row of a specified worksheet.
存档之后，从审计日志表中删除老的条目。
Once archived, those old entries are removed from the audit log tables.
定位到下面所示的(注册表)键并删除该键。
发出下面的命令来检查是否为表空间启用了对被删除表的恢复支持，如果没有启用，就打开它。
Issue the commands below to check whether a table space is enabled for dropped table recovery and if not, turn it on.
然后该信息被格式化为一个可显示的html表，连同用于修改数量或删除商品的适当控件。
This information is then formatted into an HTML table for display, together with appropriate controls to modify quantities or delete items.
您可以应用规范化的概念删除表的冗余部分，然后将它们放在次表中。
You could apply the concept of normalization to remove redundant portions of the tables and place them in secondary tables.
那意味着，无论何时添加或删除分区，都必须在分区表的所有现有索引中添加或删除对应记录。
This meant that whenever partitions were added or removed, corresponding records had to be added to or removed from any indexes that existed for the table.
TRUNCATE 表语句此语句无需激活触发器即可快速删除整个表的内容。
TRUNCATE table statement This statement quickly deletes the contents of an entire table without firing triggers.
然而，这个注册表变量只能在实例启动时生效，所以，如果您想修改DB2在mdc表上的删除操作方面的行为，必须重新启动实例。
However, this registry variable can only take effect on instance startup, so if you want to alter the behavior of DB2 with respect to deletions on MDC tables, you have to restart the instance.
“数据删除”指定从此表中删除数据的时间间隔。
Data delete specifies the interval at which data from this table is deleted.
可以在原来发布服务的注册表中删除服务，也可以在服务被同步到的注册表中删除它们，这两种情况有很大差异。
There is a big difference between deleting services in the registries where they were originally published, versus deleting services in registries where they were synchronized to.
如果没有包括任何where子句，则删除表中的所有行。
If no WHERE clause is included, all rows in the table are deleted.
后面的方法对于等待分离完成的自动化非常有用，这有助于序列化目标表上的后续活动(例如，删除或者归档)。
The latter method can be particularly useful for automating the wait for completion of detach to help serialize the subsequent action (for instance, drop or archive) on the target table.
由于这些表持续增长，所以wip操作员需要定期将已废弃的信息从这些表中删除。
Since these tables keep growing, the WIP operator needs to periodically remove from these tables the information that is obsolete.
而且要能够对过去仓库处理活动的任何历史加以恢复；备份文件应该包含从档案表中删除的数据。
And also that any past history of the warehouse processing activity can be recovered; backup files should contain the data that has been deleted from the archive table.
日期和时间应该早于运行错误的应用程序(即删除表中的行)的时间。
The date and time should be prior to when the bad application ran (when you deleted the table rows).
但是，一般地，您不希望删除表中的所有行；而是有选择地删除行。
In general, however, you don't want to delete all rows from a table; instead, you'll selectively delete rows.
此列捕获从系统周期时态表中删除该行时的时间戳。
This column captures the timestamp when the row is deleted from the system-period temporal table.
在异步分离操作完成了分离后，可以看到分离的目标表已被归档、删除、或者附加到一些(其他)表上。
After the asynchronous detach operation has completed the detach, the target table of detach is available to be archived or dropped or attached to some (other) table.
在DB2中运行在线备份的惟一约束是：当一个表空间正在被备份的时候，不能删除这个表空间。
The only restriction when running an online backup in DB2 is that you cannot drop a table space while that table space is actively being backed up.
基于被修改复制表的新模式创建一个新的删除表。
Creates a new delete table based on the new schema of the altered replicated table.
表中信息的添加、删除和更新将导致数据变得杂乱，检索杂乱的数据更为费时。
Additions, deletions, and updates of information in the tables cause the data to become disorganized, and retrieving disorganized data is more time-consuming.
在这个场景中，修改了表模式，完全删除了副表和一些分解的列。
In this scenario, you modified the table schema and completely dropped the side tables and some of the shredded columns.
从您装载的表中删除被修剪过的行，确保以后不会将重复的行装载到表中，这是一种很好的做法。
It is a good practice to delete any pruned rows from the table that you loaded in order to ensure that you do not load duplicate rows into the table at a later time.
结果我们比以前多了很多的表，但添加和删除索引却很容易。
As a result, we end up having more tables than we had before, but adding and removing indexes is easy.
DB 2将历史表中所删除行的结束时间设置为与delete语句的最新事务相关联的开始时间。
DB2 sets the end time of the deleted row in the history table to the start time that is associated with the most recent transaction of the delete statement.
确信服务器有足够的锁资源数，用以修改相关的删除表和复制表。
Confirm that the server has a sufficient number of lock resources to alter the associated delete table along with the replication table.
应用推荐