create a unique constraint to ensure no duplicate values are entered in specific columns that do not participate in a primary key.
创建唯一约束可确保在不参与主键的特定列中不输入重复值。
the unique constraint is created in the database when you save the table.
当保存表时,将在数据库中创建该唯一约束。
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资料型别。
is it possible to create a unique constraint across multiple child tables?
可以创建一个唯一跨多个子表的约束?
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 的惟一约束,如下所示
the unique constraint violation conflict has been resolved by mark method.
运用标记法解决唯一性沖突;
can「t remove unique constraint since it」s the primary key of a table.
唯一约束是表的主键,因此不能移除。
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.
当想要更改约束所附加到的列、更改约束名称或设置约束的附加属性时,可修改唯一约束。
a unique constraint guarantees that there are no duplicates in a specific column and allows you to define a primary key.
唯一约束可以保证在特定的列中没有重复值并允许您定义一个主键。
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.
当将唯一约束附加到允许空值的列时,请确保在约束的列中最多有一行包含空值。
this clause is not allowed if the column is specified in the primary key, or in a unique constraint of the table (sqlstate 42831).
如果表的主键或惟一性约束中指定了这个列,那么不允许使用这个子句(sqlstate42831)。
when you select the type, the appropriate dialog box opens ( unique constraint or foreign key constraint) to help you create the constraint.
显示适当的对话框(唯一约束或外键约束),从而允许您更改约束的属性。