Using the grid, you just need to execute the alter table SQL statement on the server where you have enabled the grid.
使用网格,您只需在启用了网格的服务器上执行SQL命令alter table。
You can easily attach and detach the partitions using the DB2 alter table command to move the data from one table (production table) to another table (history table) in the same database.
您可以很容易使用DB 2alter table命令来附加和分离分区,从而将数据从一个表(生产表)移动到同一个数据库的另一个表(历史表)中。
The ALTER COLUMN SET DATA type option on the ALTER TABLE statement has been extended to support all compatible types.
ALTER table语句中的ALTERCOLUMNSETDATATYPE选项进行了扩展,可以支持所有兼容的类型。
SQL described tables and indexes can also be placed and moved by the corresponding ALTER TABLE or ALTER INDEX commands.
SQL描述的表和索引也可以通过对应的ALTER TABLE或 ALTERINDEX命令放置和移动。
Before you execute the generated script reorg.sql, you need to create the ALTER TABLE statements to activate value compression.
在执行生成的reorg . sql脚本之前,需要创建ALTER table语句,以激活值压缩。
This is done by ALTER TABLE statements.
这是通过ALTER TABLE语句来完成的。
The ALTER table statement is used to add or drop columns in an existing table.
ALTER TABLE语句可以用来给现有的表进行添加或是删除栏目的操作。
There is no actual new functionality here, but formerly you had to say ALTER TABLE to do these things, which was confusing.
这样也没带来什么新功能,不过以前都是用ALTER TABLE来做这件事,很让人迷惑。
Some operations like ALTER table require no cursor to be open, while others like CREATE INDEX ONLINE allow cursors on the table.
ALTER TABLE等一些操作要求不打开游标,而CREATEINDEXONLINE等其它操作则允许表上的游标。
The following example demonstrates how to rename a column using the ALTER table command while keeping the table fully accessible.
下面的示例演示了如何使用ALTER TABLE命令重命名一个列,同时保持表具有完整的可访问性?
When there are no dependent materialized query tables (MQT), the system initiates the second phase after the first phase (ALTER table DETACH PARTITION) commits.
当不存在依赖的物化查询表(MQT)时,系统在完成第一阶段(ALTER TABLEDETACHPARTITION)的提交后,启动第二阶段。
A new, empty partition can be added to a partitioned table by executing the ALTER TABLE statement with the ADD PARTITION option specified; the syntax used looks like this
可以通过执行ALTER TABLE语句并指定ADDPARTITION选项来向一个分区表增加一个新的空分区,使用的语法如下所示
You can enable versioning of the temporal table by using the ALTER table command with the ADD versioning clause and specifying the history table name in the use history table clause (see Listing 3).
您可以使用ALTER TABLE命令和ADDversioning子句,并在USEHISTORY table子句中指定历史表名称,为时态表启用版本控制(参见清单3)。
You can enable versioning of the temporal table by using the ALTER table command with the ADD versioning clause and specifying the history table name in the use history table clause (see Listing 3).
您可以使用ALTER TABLE命令和ADDversioning子句,并在USEHISTORY table子句中指定历史表名称,为时态表启用版本控制(参见清单3)。
应用推荐