This is done by ALTER TABLE statements.
这是通过ALTER TABLE语句来完成的。
Why does this ALTER TABLE query throw syntax error?
为什么这个改变表查询把语法错误?
Columns can be renamed online using the ALTER TABLE statement.
使用ALTER table语句在线重命名列。
You can create a table WITH AUDIT clause or alter table ADD|DROP AUDIT clause.
您可以创建一个表格WITHAUDIT 子句,或者改变表格ADD|DROP AUDIT 子句。
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语句将执行以下步骤。
Note, however, that the ALTER TABLE statement only allows you to increase the inline length.
但是要注意,ALTER table语句只允许增加inlinelength。
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等其它操作则允许表上的游标。
The script below will scan for AW fact tables named using the wildcard expression % _measures and scripts ALTER table and REORG commands.
以下脚本将使用通配符表达式% _ MEASURES以及脚本alter TABLE和REORG命令扫描指定的aw事实表。
This can be added to existing tables using the ALTER table statement, or the row change timestamp column can defined when creating a new table.
这可以通过ALTER table语句添加到现有表,或者在创建新表时定义行修改时间戳列。
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语句也受到有限的支持。
Rows that have not been updated since the ALTER TABLE statement will return the type default value for the column, which is midnight Jan 01, year 1.
自alter table语句之后未进行更新的行将返回列的类型默认值,该值为0001年1月1日午夜。
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参数值具有更高的优先权。
应用推荐