The referenced unique or primary key constraint on the parent table or view must already be defined.
引用唯一或主键约束,必须是父表中已经定义的。
This includes both DDS-created files and SQL indexes as well as physical files with a Primary Key constraint.
这包括DDS创建的文件和SQL索引,以及带有Primary Key约束的物理文件。
When a primary key constraint is defined, the federated system automatically creates a unique index specification.
当定义一个主键约束时,联邦系统自动创建一个惟一的索引规范。
You can attach multiple unique constraints to a table, whereas you can attach only one primary key constraint to a table.
可将多个唯一约束附加到表,但是只能将一个主键约束附加到表。
Note that if the physical file is keyed (perhaps because it has a Primary key constraint), its index will also be moved on or off of SSD with these commands.
注意,如果物理文件使用了键控(可能因为它有一个Primary Key约束),其隐式索引也将通过这些命令被移动到SSD或从中移出。
As shown in Figure 16, the bulk load operation results in two of the sample records being sent to the reject link because they violate the unique primary key constraint.
如图16所示,两个示例记录中的批量加载操作结果被发送给拒绝链接,因为它们违反唯一的主键约束。
To enforce that specified keys are unique with respect to the specific time period, specify the primary key constraint BUSINESS_TIME WITHOUT OVERLAPS as the last item with the list of other keys.
要确保指定的键在特定时间段内是惟一的,可以指定主键约束BUSINESS_TIMEWITHOUTOVERLAPS作为包含其他键的列表中的最后一项。
The latter is actually a primary key lookup against the parent table and constitutes the foreign key constraint verification.
索引扫描实际上是对父表进行主键查找,并完成外键约束验证。
Syscat.tabconst Contains a row for each unique (u), primary key (p), foreign key (f), or table check (k) constraint db2 select constname, tabname, type from syscat.tabconst.
tabconst为每个唯一性(U)、主键(p)、外键(f)或者表检查(K)约束保持一个行db2select constname,tabname,typefrom syscat . tabconst。
This clause is not allowed if the column is specified in the primary key, or in a unique constraint of the table (SQLSTATE 42831).
如果表的主键或惟一性约束中指定了这个列,那么不允许使用这个子句(SQLSTATE 42831)。
Find the constraint name for the unique/primary key, disable the constraint and drop the tablespace again.
找到那些惟一/主键约束名,禁用这些约束然后再次删除表空间。
Tables must have the same primary key, unique index, or unique constraint.
表必须具有相同的主键、唯一索引或唯一约束。
A Unique constraint guarantees that there are no duplicates in a specific column and allows you to define a primary key.
唯一约束可以保证在特定的列中没有重复值并允许您定义一个主键。
Create a unique constraint to ensure no duplicate values are entered in specific columns that do not participate in a primary key.
创建唯一约束可确保在不参与主键的特定列中不输入重复值。
Such a constraint is intended to be used with primary key columns.
这种约束旨在用于主键列。
Can't remove unique constraint since it's the primary key of a table.
唯一约束是表的主键,因此不能移除。
A primary key is a constraint that assures that each table contains no duplicate rows.
主键是确保每个表都不包含重复行的约束。
A primary key is a constraint that assures that each table contains no duplicate rows.
主键是确保每个表都不包含重复行的约束。
应用推荐