For the create table statement this is desirable.
对于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脚本创建表定义。
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视图允许为表创建表检查约束。
While the create table space operations are running, execute the following script from another session.
在执行创建表空间的操作时,从另一会话执行下列脚本。
I also described two ways to use the partition BY clause of the create table statement to create partitioned tables.
我还描述了使用CREATE TABLE的PARTITIONBY子句来创建分区表的两种方法。
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语句发送到数据源,并为这个新表创建一个昵称。
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。
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表中。
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的语法仍然和以前一样。
You define a partition key for a table on the CREATE TABLE statement.
要在CREATE TABLE语句中指定表的分区键。
The page size is not directly specified on the CREATE TABLE statement.
页宽不是在CREATE table语句中直接指定的。
A partitioning key is defined on a table with the CREATE table statement.
分区键是在一个表上用CREATE table语句定义的。
You can use this dialog to build a subsection of the SQL CREATE TABLE command.
可以使用该对话框构建SQLCREATE TABLE 命令的子区段。
You can also create your own conversion tables using the Create Table (CRTTBL) command.
您还可以使用Create Table(CRTTBL)命令创建自己的转换表。
TABLE data is partitioned as specified in the partition BY clause of the CREATE TABLE statement.
CREATE table语句的PARTITIONBY子句指定了表数据的分区。
The most interesting thing in the CREATE TABLE statement shown is the several foreign_key_* columns.
所示的 CREATE TABLE语句中最有意思的是几个 foreign_key_*列。
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语句。
The dimensions are defined in the CREATE table statement and storage is reserved for each combination of values.
在CREATE table语句中定义维的时候,就为每种值的组合预留了存储空间。
If there is no partitioning key provided explicitly in the CREATE TABLE command, the following defaults are used.
如果在CREATE TABLE命令内没有显式地提供分区键,那么就会使用如下的这些默认值。
Edit the generated SQL script adding the COMPRESS YES clause to the CREATE table statement for the noted fact tables.
编辑生成的sql脚本,对于标记的事实表添加COMPRESSyes子句到CREATE table语句。
If a primary key is specified in the CREATE TABLE statement, the first column of the primary key is used as the distribution key.
如果在CREATE table语句中指定了一个主键,那么主键的首列会被用作分配键。
Membership of a group that has sufficient authority to issue TRUNCATE TABLE statements and have CREATE TABLE statement privileges.
一组成员,拥有足够的授权来发出TRUNCATEtable语句且拥有CREATE table语句权限。
Now, when creating partitioned tables, the partition boundaries are determined by the CREATE table statement instead of CREATE INDEX.
这时,当创建分区的表时,分区的边界由CREATE table语句决定,而不是由CREATEindex语句决定。
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语句中指定的分区键,表中的每个行被分布到一个分区上。
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语句定义示例表和数据。
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)。
应用推荐