它删除表(参见清单13)。
还可在该工作区中间删除表。
The tables can also be deleted centrally from this workspace.
在IDS中创建和删除表。
要从通知数据库中删除表。
要从日志数据库中删除表。
在完成后,后台线程删除表中的艺术家。
When finished, the background thread deletes the Artist from the table.
要从内容存储中删除表。
删除表空间的物理文件并重新创建这些文件。
为什么DB2返回1时删除表中的所有行吗?
如果没有包括任何where子句,则删除表中的所有行。
If no WHERE clause is included, all rows in the table are deleted.
基于被修改复制表的新模式创建一个新的删除表。
Creates a new delete table based on the new schema of the altered replicated table.
您可以通过使用“删除”查询删除表中的所有行。
清单4中在新创建的临时表上演示了删除表的过程。
The process of dropping a table is demonstrated on a newly created temporary table in Listing 4.
说明如何使用服务器资源管理器从现有数据库中删除表。
Describes how to use Server Explorer to delete tables from an existing database.
日期和时间应该早于运行错误的应用程序(即删除表中的行)的时间。
The date and time should be prior to when the bad application ran (when you deleted the table rows).
在一些后续步骤中,您需要用到被删除表备份id和DDL。
You will need the backup ID and the DDL for the dropped table in the subsequent steps.
确信服务器有足够的锁资源数,用以修改相关的删除表和复制表。
Confirm that the server has a sufficient number of lock resources to alter the associated delete table along with the replication table.
在使用SQL修改这些表属性时,不再需要删除表并重新创建它。
When changing these table attributes using SQL, it is no longer necessary to drop the table and then recreate it.
但是,一般地,您不希望删除表中的所有行;而是有选择地删除行。
In general, however, you don't want to delete all rows from a table; instead, you'll selectively delete rows.
找到那些惟一/主键约束名,禁用这些约束然后再次删除表空间。
Find the constraint name for the unique/primary key, disable the constraint and drop the tablespace again.
您可以应用规范化的概念删除表的冗余部分,然后将它们放在次表中。
You could apply the concept of normalization to remove redundant portions of the tables and place them in secondary tables.
简单的答案是从数据库中删除表。而且,如果必要,再创建一个替代表。
The simple answer is to delete the table from the database and, if necessary, create a replacement table.
可以使用表设计器创建、编辑或删除表、列、键、索引、关系和约束。
You can use table Designer to create, edit, or delete tables, columns, keys, indexes, relationships, and constraints.
当修改删除表时,EnterpriseReplication执行以下四步。
When altering the delete table, Enterprise Replication performs these four steps.
除了能够创建新表之外,您可能还想删除表—只有在偶然犯了输入错误或不再需要特定表时。
Apart from the ability to create new tables, you might also want to delete tables-only if you've made an accidental typing mistake, or when you no longer need a particular table.
例如,您可能需要浏览数据库,修改或删除表,执行扩展修改,在现有的表中添加列。
For example, you can browse your database for tables that need to be modified or dropped, perform extended alters, and add columns to an existing table.
额外其它的函数有:创建表(给定每个表一个名称),删除表和获取数据库的信息。
Additional functions let you create tables (giving each table a name), remove tables, and obtain information about the database.
我们可以使用tg -adminsqlhelp找到更多命令,包括删除表的命令。
You can find more commands using tg-admin SQL help, including a command to drop tables.
在某些情况中,您还需要删除表以及表中的所有数据,修改数据库的设计,然后重新加载数据。
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.
应用推荐