So, it violates unique constraint across the collection.
所以,它违背了独特的约束集合。
Can't remove unique constraint since it's the primary key of a table.
唯一约束是表的主键,因此不能移除。
The unique constraint is created in the database when you save the table.
当保存表时,将在数据库中创建该唯一约束。
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.
唯一约束可以保证在特定的列中没有重复值并允许您定义一个主键。
You can attach multiple unique constraints to a table, whereas you can attach only one primary key constraint to a table.
可将多个唯一约束附加到表,但是只能将一个主键约束附加到表。
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)。
Create a unique constraint to ensure no duplicate values are entered in specific columns that do not participate in a primary key.
创建唯一约束可确保在不参与主键的特定列中不输入重复值。
When you select the type, the appropriate dialog box opens (Unique constraint or Foreign Key constraint) to help you create the constraint.
显示适当的对话框(唯一约束或外键约束),从而允许您更改约束的属性。
When you attach a unique constraint to a column allowing null values, you ensure that at most one row will have a null value in the constrained column.
当将唯一约束附加到允许空值的列时,请确保在约束的列中最多有一行包含空值。
The column 'CITY' in the OFFICE_INFO nickname is unique and hence a unique constraint has been defined on the nickname OFFICE_INFO on column CITY as follows.
office_info昵称中的列'CITY '是惟一的,因此在列city上定义了昵称OFFICE_INFO的惟一约束,如下所示。
Because the Regular Expression generator is not guaranteed to produce unique values, you cannot use it to fill a user-defined type column that has a unique constraint.
由于无法保证规则运算式产生器一定会产生唯一的值,所以您不能使用它来填满具有唯一条件约束的使用者定义型别资料行。
When you try to assign a data generator to a column that has a unique constraint, the list of available generators displays only generators that can produce unique values.
当您尝试将资料产生器指派给具有唯一条件约束的资料行时,可用产生器的清单只会显示可以产生唯一值的产生器。
Modify a unique constraint when you want to change the columns that the constraint is attached to, change the constraint name, or set additional properties for the constraint.
当想要更改约束所附加到的列、更改约束名称或设置约束的附加属性时,可修改唯一约束。
Delete a unique constraint when you want to remove the requirement for uniqueness for values entered in the column or combination of columns included in the constraint expression.
当希望移除对在约束表达式所包含的列或列组合中输入的值的唯一性要求时,可删除唯一约束。
You can assign a custom data generator that does have filter attributes to a SQL data type that can have a unique constraint only if the custom data generator can produce unique values.
只有在自订资料产生器可以产生唯一值时,您才可以将具有筛选属性的自订资料产生器指派给SQL 资料型别。
But from our data model's perspective, there is no unique table we can use to create our foreign key constraint, like the one between TB_RIGHT and TB_PERSON.
但是从我们数据模型的角度来看,我们没有一个惟一的表可以用来创建我们的外键约束,就像TB_RIGHT和TB_PERSON之间那样。
When a primary key constraint is defined, the federated system automatically creates a unique index specification.
当定义一个主键约束时,联邦系统自动创建一个惟一的索引规范。
Constraints Supports, primary, foreign, unique, not null constraint.
约束支持主键、外键、惟一和非空约束。
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作为包含其他键的列表中的最后一项。
You have an index that is associated with a Unique or Foreign Key constraint that is heavily used in queries that you want to put on SSD.
您有一个索引与Unique或ForeignKey约束关联并且该索引被大量的查询所使用,您希望将这个索引放入SSD。
A constraint unique to this ecosystem is the fact that Big Data likes to be at rest.
这个生态系统的惟一约束是BigData喜欢处于静止状态这个事实。
Id-a unique identifier for the constraint.
id -约束的惟一标识符。
The itemNumber column provides a unique identity for each item (or row) and has an attached column-level constraint that enforces a valid value to always be supplied (NOT NULL).
itemNumber列提供了每个商品(或列)的惟一标识,它上面还有列级约束,强制要求提供正确的值(NOT NULL)。
Once you've rerun the test to ensure that it passes, it's time to tackle a slightly more tricky constraint: unique.
在重新运行测试以确保其通过时,可以解决一个稍微棘手一些的约束:unique。
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。
One constraint of this concept you must address is that all resource names of a given type of resources (instances, images, storages) of a user should be unique.
本概念中一个您必须解决的局限是,用户特定类型资源(实例、映像和存储)中所有资源的名称都必须是独一无二的。
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所示,两个示例记录中的批量加载操作结果被发送给拒绝链接,因为它们违反唯一的主键约束。
Note: Did I mention that all those names you put after constraint must be unique across your database?
注:我是否曾提到过放在constraint之后的所有那些名称在整个数据库中必须是惟一的?
The schema constraint count(key('ids', .)) = 1 checks the set of all identifiers to be sure that only one has the current value (in other words whether the identifier is unique).
模式将限定count(key('ids',.) ) =1检查所有的标识符,从而确保只有一个包含当前值(换句话说,确定该标识符是否是惟一的)。
应用推荐