闪回后,把删除的表,及索引都会恢复。
如果从一个带有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.
清单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.
install文件现在可以包含一个hook_uninstall函数,它用来删除模块创建的任何表和变量。
The module.install file can now include a hook_uninstall function to delete any tables and variables that your module may have created.
TableName:按照名称指定将从中删除分区的分区表。
TableName: Identifies the partitioned table, by name, that a partition is to be removed from.
最后使用查找程序是删除这个对象的注册表。
The final aspect of using the find method deals with deleting registration of the object. TestObject.find
在某些情况中,您还需要删除表以及表中的所有数据,修改数据库的设计,然后重新加载数据。
In some cases, you may have to unload the tables, delete all the data, change the database design, then reload the data.
发出下面的命令来检查是否为表空间启用了对被删除表的恢复支持,如果没有启用,就打开它。
Issue the commands below to check whether a table space is enabled for dropped table recovery and if not, turn it on.
您可以应用规范化的概念删除表的冗余部分,然后将它们放在次表中。
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.
“数据删除”指定从此表中删除数据的时间间隔。
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.
该用户需要在SAMPLE数据库中创建、修改和删除数据表的权利。
The user needs to have rights to create, modify, and delete tables in the SAMPLE database.
如果没有包括任何where子句,则删除表中的所有行。
If no WHERE clause is included, all rows in the table are deleted.
而且要能够对过去仓库处理活动的任何历史加以恢复;备份文件应该包含从档案表中删除的数据。
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.
这些操作都要求用户检索将要修改或删除的工作表条目,根据需要对条目作出修改,然后将其传递回服务器以完成执行。
Both these operations require the user to retrieve the worksheet entry to be modified or deleted, make changes to the entry as required, and then transmit it back to the server for execution.
每当数据库的模式发生更改,或者进行像添加或删除数据文件、添加或删除表空间这样的更改时,建议管理员执行脱机备份。
Administrators are advised to do an offline backup whenever the schema of the database changes, or changes are made such as adding or removing data files, and adding or removing of table Spaces.
日期和时间应该早于运行错误的应用程序(即删除表中的行)的时间。
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.
在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.
最佳实践:为节省分析数据库的空间,应当从旧有运行中删除不需要的输出表。
Best practice: To save space in the analysis database, you should delete the output tables from older runs when they are no longer needed.
在这个场景中,修改了表模式,完全删除了副表和一些分解的列。
In this scenario, you modified the table schema and completely dropped the side tables and some of the shredded columns.
清单4演示了删除清单3中的工作表。
Listing 4 has an example of deleting the worksheet from Listing 3.
从您装载的表中删除被修剪过的行,确保以后不会将重复的行装载到表中,这是一种很好的做法。
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.
确信服务器有足够的锁资源数,用以修改相关的删除表和复制表。
Confirm that the server has a sufficient number of lock resources to alter the associated delete table along with the replication table.
应用推荐