When altering the delete table, Enterprise Replication performs these four steps.
当修改删除表时,EnterpriseReplication执行以下四步。
Creates a new delete table based on the new schema of the altered replicated table.
基于被修改复制表的新模式创建一个新的删除表。
To delete tables from the Server Explorer tree, right-click on the appropriate table node in the tree, and choose the delete option.
要从Serverexplorer树中删除表,右键单击树中相应的表节点,然后选择Delete选项。
Confirm that the server has a sufficient number of lock resources to alter the associated delete table along with the replication table.
确信服务器有足够的锁资源数,用以修改相关的删除表和复制表。
It needs enough space to perform the alter operation on the associated delete table, along with the alter operation on the replicated table.
它需要足够的空间来执行对相关的删除表的alter操作,以及对复制表的alter操作。
Otherwise, the deleted row is moved from replication table to the associated delete table, which might cause problems for the subsequent alter operation on the replicated table.
否则,被删除的行将被从复制表转移到相关的删除表,这样会给随后对复制表的alter操作带来问题。
Delete a row from a table with 10 indexes, and DB2 must remove all index entries associated with the deleted rows.
如果从一个带有10个索引的表删除一行,DB 2必须删除与被删除的行关联的所有索引条目。
You should try to use the fastest disc you have for this kind of data and also regularly back up and delete the entries in this table.
您应该尝试使用速度较快的磁盘用于此类数据的保存,并且有经常性地备份和删除该表格中的记录。
Sometimes an application needs to delete all records from a given table to clean up a log or reload sales data for a new month.
有时候应用程序需要从给定表中删除所有的记录,以便清空日志记录或者装入新的一个月的销售数据。
The simple answer is to delete the table from the database and, if necessary, create a replacement table.
简单的答案是从数据库中删除表。而且,如果必要,再创建一个替代表。
This method takes three parameters, the primary key, the action performed on the table (create, update, delete) and a result set.
此方法具有三个参数,主键、对表执行的操作(创建、更新、删除)和结果集。
If a row has already been updated or deleted, then this row cannot be joined again with any source table row for another update or delete again.
如果一个行已被更新或者删除,那么不能针对该行再次更新与删除,再次与任何源表联接。
Enter this command to delete the value in the table that allows indexes to be created for multiline text fields.
键入这个命令来删除表格中允许为多行文本文件创建索引的值。
We'll be using the "inbound interface" of this adapter to kick-off business processes when a create, update, or delete occurs in a database table.
当数据库表中发生创建、更新或删除事件时,我们将使用该适配器的“入站接口”来调用业务流程。
Once the table Q1_2010_SALES becomes available, you can either drop it (to delete the data) or attach it to another partitioned table (for example, to archive it).
一旦表q 1_2010_sales变得可用,可以删除它(以删除数据),或者将其添加到另一个分区表(例如,以对其存档)。
DML commands are used to add, modify, delete, or select data from a table in the database.
DML命令用来在数据库表中添加、修改、删除或选择数据。
In general, however, you don't want to delete all rows from a table; instead, you'll selectively delete rows.
但是,一般地,您不希望删除表中的所有行;而是有选择地删除行。
Data delete specifies the interval at which data from this table is deleted.
“数据删除”指定从此表中删除数据的时间间隔。
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.
从您装载的表中删除被修剪过的行,确保以后不会将重复的行装载到表中,这是一种很好的做法。
You can now define multiple INSERT, DELETE, UPDATE, and SELECT triggers on a table and multiple INSTEAD OF triggers for the view.
现在可以在一个表上定义多个INSERT、DELETE、UPDATE和SELECT触发器,也可以在一个视图上定义多个INSTEADOF 触发器。
Add, edit, and delete elements of a table or matrix.
表格或者矩阵元素的添加,编辑以及删除。
You could manually delete the HTML table tags from source, or you could configure the Faces Library Definition so that it can use this configuration on other pages and in other projects.
您可以从源中手动地删除HTML表格编辑,或者您可以配置FacesLibraryDefinition,这样它就可以在其他的页面上及其他的项目中使用该配置了。
In the sample code, we have created three Triggers on the customer table for Insert, Update, and Delete.
在示例代码中,我们在customer表上创建了三个触发器,分别用于Insert、Update和Delete操作。
To avoid analyzing duplicate records, you delete rows from the CHECKING table with a timestamp greater than the one you pruned the pruned the audit log with.
为了避免分析重复的记录,从checking表中删除时间戳大于一个指定的、用于修剪日志的时间戳的行。
Delete the entire content of the CCD table.
删除ccd表所有内容。
If you've already populated your Clients table, you might find it convenient to delete its contents or drop and recreate the table.
如果已经填充了clients表,那么您可能会发现可以很方便地删除它的内容或销毁并重新创建表。
Release the row locks so that other applications can SELECT, INSERT, UPDATE, and DELETE from the table (for example, use isolation level cursor stability or uncommitted read).
释放行锁,以便其他应用程序可以对表执行SELECT、INSERT、UPDATE和DELETE(例如,使用游标稳定性(curs or stability)隔离级别或未提交读(uncommitted read)隔离级别)。
Truncate - to delete the records in the existing table.
截去—删除已有表中的记录。
Switch to the report Design perspective and delete the table from the work items report that you created in the previous article.
切换至Reportdesign视角,并从您在前文中所创建的工作项报表中删除掉表格。
Select the Truncate table action to delete all the existing rows in the Orders table before the data load operation starts.
在数据加载操作开始之前,选择truncate表操作删除orders表中的所有已有行。
应用推荐