Three complementary CREATE TABLE options.
三个互补的CREATE TABLE选项。
For the create table statement this is desirable.
对于create table语句而言,这是一种理想状况。
You can use its create table wizard, as shown in Figure 1.
可以使用它提供的创建表向导,如图 1 所示。
And obviously, the CREATE TABLE doesn't return anything.
显然,CREATE TABLE没有返回任何东西。
You define a partition key for a table on the CREATE TABLE statement.
要在CREATE TABLE语句中指定表的分区键。
Every CREATE TABLE statement includes a primary_key and seq column.
每个CREATE table语句都包括一个primary_key和seq列。
Please note the syntax for CREATE TABLE remains the same as before.
请注意CREATE TABLE的语法仍然和以前一样。
A partitioning key is defined on a table with the CREATE table statement.
分区键是在一个表上用CREATE table语句定义的。
Notice in Listing 10, the SQL statement create table PURCHASE_ORDERS.
注意清单10中的sql语句create table PURCHASE_ORDERS。
For DDL, you will use generated db2ddl script to create table definitions.
对于ddl,使用生成的db2ddl脚本创建表定义。
The page size is not directly specified on the CREATE TABLE statement.
页宽不是在CREATE table语句中直接指定的。
As mentioned, dtd2sql simply produces a set of CREATE TABLE statements.
前面提到过,dtd2s ql只产生一组CREATE table语句。
You can use this dialog to build a subsection of the SQL CREATE TABLE command.
可以使用该对话框构建SQLCREATE TABLE 命令的子区段。
The CREATE table statement now provides three ways to group data in a database table.
CREATE table语句现在提供了三种方式来组织数据库表中的数据。
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视图允许为表创建表检查约束。
You can also create your own conversion tables using the Create Table (CRTTBL) command.
您还可以使用Create Table(CRTTBL)命令创建自己的转换表。
The partition level INDEX in clause is specified in the CREATE TABLE statement, or.
语句create TABLE中指定了分区级别的INDEXin子句,或者。
Consult the DB2 UDB documentation for the actual CREATE TABLE statements you should use.
关于应该使用的实际的CREATE table语句,请参阅DB 2UD b文档。
Consider the simple example of two statements targeted for table T1 - CREATE table T1 (C1 INT).
考虑一个简单的例子,例子中有两个以表t 1为目标的语句——CREATE TABLET1 (C1INT)。
TABLE data is partitioned as specified in the partition BY clause of the CREATE TABLE statement.
CREATE table语句的PARTITIONBY子句指定了表数据的分区。
In this example, you see that the "Create table" statement failed to propagate on target servers.
在本例中,您将看到“Create table”语句未能广播到目标服务器。
While the create table space operations are running, execute the following script from another session.
在执行创建表空间的操作时,从另一会话执行下列脚本。
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语句。
So in the above CREATE TABLE example, dtd2sql identified the DTD element definitions shown in Listing 4.
所以在上述CREATE TABLE示例中,dtd2s ql标识了在清单4中显示的dtd元素定义。
This can be performed by invoking the CREATE TABLE statement using the CCSID UNICODE clause. For example.
这可以通过调用使用了CCSIDunicode子句的CREATE table语句来执行。
The statement at D results in an error because the CREATE TABLE statement for the t1 table has been rolled back.
标签D的语句导致一个错误,因为t1表的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命令内没有显式地提供分区键,那么就会使用如下的这些默认值。
应用推荐