Why does this ALTER TABLE query throw syntax error?
为什么这个改变表查询把语法错误？
Columns can be renamed online using the ALTER TABLE statement.
使用ALTER table语句在线重命名列。
The ALTER table statement is used to add or drop columns in an existing table.
ALTER TABLE语句可以用来给现有的表进行添加或是删除栏目的操作。
The second algorithm is used when the table is placed in APPEND mode through ALTER table.
当表是通过ALTER table以append模式放置时，就要使用第二种算法。
According to this sample, the following steps will be executed by ALTER TABLE statements.
对于这个示例，ALTER table语句将执行以下步骤。
Instead, you must create the table without the constraint and then add it later with an ALTER table statement.
相反，你必须创建一个没有约束的表，然后添加alter TABLE语句。
Your database user needs quite a lot database permissions, including alter table, drop table, same for index etc.
数据库用户需要相当多的权限，包括修改表格，放下表格，索引一类的也一样。
The ALTER COLUMN SET DATA type option on the ALTER TABLE statement has been extended to support all compatible types.
ALTER table语句中的ALTERCOLUMNSETDATATYPE选项进行了扩展，可以支持所有兼容的类型。
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。
SQL described tables and indexes can also be placed and moved by the corresponding ALTER TABLE or ALTER INDEX commands.
SQL描述的表和索引也可以通过对应的ALTER TABLE或 ALTERINDEX命令放置和移动。
There is no actual new functionality here, but formerly you had to say ALTER TABLE to do these things, which was confusing.
这样也没带来什么新功能，不过以前都是用ALTER TABLE来做这件事，很让人迷惑。
The following example demonstrates how to rename a column using the ALTER table command while keeping the table fully accessible.
下面的示例演示了如何使用ALTER TABLE命令重命名一个列，同时保持表具有完整的可访问性？
Before you execute the generated script reorg.sql, you need to create the ALTER TABLE statements to activate value compression.
在执行生成的reorg . sql脚本之前，需要创建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等其它操作则允许表上的游标。
In combination with enhancements to the ALTER TABLE statement, a convenient way for managing different versions of a database solution was created.
再结合使用对ALTER table语句的改进，就可以方便地管理数据库解决方案的不同版本。
Thus, if you wanted to add an empty partition to a partitioned table named SALES, you could do so by executing an ALTER table statement similar to this.
这样，如果您想添加一个分区表名为SALES的空分区，可以执行一个与下面类似的ALTER table语句。
In conversions to DB2 9.1, the ALTER TABLE statement with data compression is supported, and limited support is provided for CREATE TABLE statement.
在到DB 2 9.1的转换中，包含数据压缩的ALTER table语句是受支持的，CREATE 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)的提交后，启动第二阶段。
You can also run other types of SQL statements, such as ALTER TABLE statements, using the ActiveRecord: : Base.connection.execute method, as shown in Listing 14.
您还可以使用ActiveRecord：Base . connection . execute方法运行其他类型的sql语句，比如alter table语句，如清单14所示。
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选项来向一个分区表增加一个新的空分区，使用的语法如下所示
But for module upgrades from module versions with older table structures, you need to add a tiny bit of module upgrade code to instruct it when to execute the ALTER table code.
但对于具有旧的表结构模块的升级，你需要添加一点模块升级代码来进行指导，以执行alter TABLE代码。
The IMPLICITLY HIDDEN attribute on a CREATE or ALTER TABLE statement specifies that the column is not visible in SQL statements unless the column is explicitly referenced by name.
CREATE或ALTER table语句中的IMPLICITLYhidden属性表示，除非根据名称显式引用列，否则该列在sql语句中不可见。
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 pagefreespace value takes precedence over the value of the PCTFREE parameter for the table, which can be changed through the ALTER TABLE statement. create table newemp like employee;
pagefreespace的值比该表中可由ALTER TABLE 语句来修改的PCTFREE参数值具有更高的优先权。
You can use ALTER TABLE with the DROP VERSIONING clause for the same purpose, but IBM suggests sparse use of DROP VERSIONING because it can cause invalidation, which should be avoided if possible.
您可以使用ALTER TABLE和DROPversioning子句实现相同用途，但IBM建议尽量少使用DROP VERSIONING，因为它可能导致无效性，这应该尽可能避免。
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)。
修改复制表。
Because this restriction is removed, even if the database is not created in UTF-8, a user can alter a table to add an XML column or create a new table with XML columns.
由于去掉了这个限制，即使数据库不是用utf - 8格式创建的，用户也可以更改一个表以添加xml列，或者创建一个包含xml列的新表。
If you attempt to alter a table to use this lock size option, and it isn't an MDC table, you will receive an SQLSTATE 628n error.
如果您尝试修改一个表，以便使用这种锁粒度选项，而那个表又不是mdc表，那么您将收到一个SQLSTATE 628n错误。
Alter the locking granularity of a table.
改变表的锁定粒度。
应用推荐