在每次测试运行之后便删除数据库person表中的所有记录。
All the records in the database PERSON table were deleted after each test run.
目标表中的任何行都不会被更新或者删除多次。
No row in the target table should be updated or deleted more than once.
理解仓库目标表中的数据为何以及何时被意外地删除。
Understand why and when data in a warehouse target table was — accidentally — deleted.
重命名旧的删除表。
在运行测试之前,从表中删除数据。
删除目标表不需要的所有结果集列。
Delete all result set columns except those required by the target table.
还可以添加和删除DB 2表中的条目。
删除初始删除表。
最后,DROPtable语句删除模式中的空表。
Finally, the DROP table statement deletes the empty table from the schema.
使用这个参数很重要;因为如果不作限制,Zend_Db将删除表中的所有记录。
Including this argument is key; without it, Zend_Db will delete all records in the table.
有些操作(例如删除表或列)也会破坏数据。
Some operations, such as dropping tables or columns, also destroy data.
然后,在第二步中,从表中删除这个元素。
Then, in a second step, the element is deleted from the table.
删除表是与复制表相关的一个影子表。
The delete table is a shadow table associated with the replicated table.
例如,如果错误删除了表,那么作为管理员,您有两种选择。
For example, if a table is mistakenly dropped, as an administrator you have two choices.
脚本可能会删除所有的表,再添加所有的表。
A script might drop all tables and add all of the tables again.
现在,在被删除表的ddl语句清单中创建被删除的表。
Now, create the dropped table from the list dropped table DDL statement.
正被删除的类型化表不能拥有任何子类型。
The typed table that is being dropped cannot have any subtables.
注意,新的系统目录表将在逆转过程中删除。
Note that the new system catalog tables will be dropped during the reversion process.
添加或删除新表。
删除列之后要求进行表重组,然后才允许进行进一步的表访问。
Dropping a column requires table reorganization before further table access is allowed.
远程表被删除。
源表必须可删除。
根据ADMIN_MOVE_TABLE输入参数之一,源表将被删除或保留。
The source table is either dropped or kept based on one of the ADMIN_MOVE_TABLE input parameters.
通过删除测试对象的注册表来清理内存。
通过发出命令来列出被删除表的历史。
在执行删除表空间的操作时,从另一会话执行下列脚本。
While the drop table space operations are running, execute the following script from another session.
最后的清理(Cleanup)阶段从数据源中删除这些表。
The final Cleanup phase removes the tables from the data source.
使用过程来删除临时表有以下两个优点
Using a procedure to drop the temporary table has these two benefits
使用完全恢复将被删除表前滚至e:\tmp。
Roll forward using complete recover dropped table to e:\tmp.
从表中删除列(remove_column)。
应用推荐