You can also create your own conversion tables using the Create Table (CRTTBL) command.
您还可以使用Create Table(CRTTBL)命令创建自己的转换表。
You define a partition key for a table on the CREATE TABLE statement.
要在CREATE TABLE语句中指定表的分区键。
To illustrate the new DB2 9.5 XML update functionality, the sample table and data defined by the following CREATE TABLE and INSERT statements are used.
为了解释新的DB2 9.5XML更新功能,我们使用下面的CREATE TABLE和INSERT语句定义示例表和数据。
The only other noticeable difference is that an additional clause can and should be appended to the CREATE TABLE statement to specify in which database the table shall be placed.
惟一需要注意的其他事项是,可以、也应该在CREATE TABLE语句后面添加一个子句,以指定将表放在哪个数据库中。
You can use its create table wizard, as shown in Figure 1.
可以使用它提供的创建表向导,如图 1 所示。
For DDL, you will use generated db2ddl script to create table definitions.
对于ddl,使用生成的db2ddl脚本创建表定义。
While the create table space operations are running, execute the following script from another session.
在执行创建表空间的操作时,从另一会话执行下列脚本。
SQL> grant create table to wanghao;
授予创建表的权限。
The check constraints view allows you to create table check constraints for the table.
允许您为表创建表检查约束。
The Check constraints view allows you to create table check constraints for the table.
Checkconstraints视图允许为表创建表检查约束。
Cannot create table. A table must have at least one cell, and the number of cells must not exceed 5,000.
无法创建表格。表格应至少有一个单元格,并且单元格数不能超过5,000。
Tip: Named anchors are often used to create "table of contents" at the beginning of a large document.
命名锚一般用于在一个长篇幅文档中建立“内容小目录”。
Creating an empty table with the same structure as an existing table can be done by specifying the LIKE option of the CREATE table command (Listing 4).
通过在CREATE TABLE命令中指定LIKE选项,创建一个与现有表结构相同的空表(清单4)。
You can create a staging table using the create table statement; then, when the underlying tables of the MQT are modified, the changes are propagated and immediately appended to the staging table.
可以使用CREATE table语句创建一个staging表。然后,当MQT的底层表被修改时,变化就会传播过来,并立即被添加到staging表中。
A partitioning key is defined on a table with the CREATE table statement.
分区键是在一个表上用CREATE table语句定义的。
You can use the PASSTHRU session to directly send the create table statement to the data source and create a nickname for this new table.
您可以使用PASSTHRU会话直接将CREATE table语句发送到数据源,并为这个新表创建一个昵称。
In a DPF environment, each table row is distributed to a database partition according to the distribution key specified in the CREATE table statement.
在DPF环境中,根据CREATE table语句中指定的分区键,表中的每个行被分布到一个分区上。
The result of the db2look call is a file sales.ddl containing the CREATE table statement for table sales.
db2look调用的结果是sales . ddl文件,其中包含sales表的CREATE table语句。
After connecting to the SAMPLE database, we create the newstaff table by issuing the following SQL statement: create table newstaff like staff.
在连接到SAMPLE数据库之后,我们通过发出下面这个sql语句创建newstaff表:create table newstafflikestaff。
The database character set and collation are used as default values if the table character set and collation are not specified in CREATE table statements.
如果在CREATE TABLE语句中没有指定表字符集和校对规则,则使用数据库字符集和校对规则作为默认值。
In DB2 9.7, the compression capability for XML data is enabled simply through the compress YES clause of the CREATE table statement, which compresses both relational and XML columns in the table.
在DB 2 9.7中,只需通过CREATE table语句的COMPRESSyes子句启用XML数据的压缩功能,这会同时压缩表中的关系和xml列。
I also described two ways to use the partition BY clause of the create table statement to create partitioned tables.
我还描述了使用CREATE TABLE的PARTITIONBY子句来创建分区表的两种方法。
The dimensions are defined in the CREATE table statement and storage is reserved for each combination of values.
在CREATE table语句中定义维的时候,就为每种值的组合预留了存储空间。
Now, when creating partitioned tables, the partition boundaries are determined by the CREATE table statement instead of CREATE INDEX.
这时,当创建分区的表时,分区的边界由CREATE table语句决定,而不是由CREATEindex语句决定。
Edit the generated SQL script adding the COMPRESS YES clause to the CREATE table statement for the noted fact tables.
编辑生成的sql脚本,对于标记的事实表添加COMPRESSyes子句到CREATE table语句。
For the create table statement this is desirable.
对于create table语句而言,这是一种理想状况。
As in previous releases, administrators use the ORGANIZE BY dimension (...) clause of the CREATE TABLE statement to specify multi-dimensional clustering.
与以前的版本一样,管理员使用CREATE table语句的ORGANIZEBYDIMENSION(…)子句指定多维聚簇。
Three complementary CREATE TABLE options.
三个互补的CREATE TABLE选项。
And obviously, the CREATE TABLE doesn't return anything.
显然,CREATE TABLE没有返回任何东西。
Please note the syntax for CREATE TABLE remains the same as before.
请注意CREATE TABLE的语法仍然和以前一样。
应用推荐