Creating a foreign key constraint with index disabled.
创建一个索引禁用的外键约束。
A relationship between the main foreign key constraint graph.
一个关系主外键约束图。
A foreign key constraint can implement referential integrity between parent and child tables.
外部索引键条件约束可于父资料表和子资料表之间,实作参考完整性。
New syntax for disabling an index for foreign key constraint was added to use with the ALTER statement.
用于为外键约束禁用索引的新语句被使用alter语句添加来使用。
In table 6, the INSERT into the Orders table fails due to a foreign key constraint violation on custno.
在表6中,对orders表执行insert语句失败,因为custno违背了外键约束。
The referenced unique or primary key constraint on the parent table or view must already be defined.
引用唯一或主键约束,必须是父表中已经定义的。
A Foreign key constraint allows you to define referential integrity between a parent and child table.
外键约束允许您定义父表和子表之间的引用完整性。
A foreign key constraint allows you to define referential integrity between a parent and child table.
外部索引键条件约束可让您在父、子资料表之间定义参考整合性。
This includes both DDS-created files and SQL indexes as well as physical files with a Primary Key constraint.
这包括DDS创建的文件和SQL索引,以及带有PrimaryKey约束的物理文件。
Delete a foreign key constraint when you want to remove the requirement to enforce referential integrity.
如果想要移除对强制引用完整性的要求,则可删除外键约束。
You cannot define a foreign key constraint in a CREATE TABLE statement that contains an AS subquery clause.
你不能在CREATETABLE语句中包含AS子查询子句定义一个外键约束。
When a primary key constraint is defined, the federated system automatically creates a unique index specification.
当定义一个主键约束时,联邦系统自动创建一个惟一的索引规范。
After the foreign key constraint with index disabled is dropped and recreated, the reversion completes successfully.
终止和重新创建索引禁用的外键之后,降级就成功完成了。
Next, select the newly added foreign key constraint in the editor and specify the key columns using the Properties view.
接下来,在编辑器中选择新添加的外键约束,并使用Properties视图指定关键列。
The latter is actually a primary key lookup against the parent table and constitutes the foreign key constraint verification.
索引扫描实际上是对父表进行主键查找,并完成外键约束验证。
To do so, click on the Add icon, and then select the database object type Foreign Key Constraint, as shown in Figure 4c.
为此,单击add图标,然后选择数据库对象类型ForeignKey Constraint,如图4c所示。
You can attach multiple unique constraints to a table, whereas you can attach only one primary key constraint to a table.
可将多个唯一约束附加到表,但是只能将一个主键约束附加到表。
Elevation directly corresponds to difficulty, and must monotonically increase, so that was a key constraint in the design.
海拔和难度是直接对应的,并且必须单调增加,所以这是游戏设计中的一个关键约束。
Give you the option to implement referential integrity between parent and child tables by creating a foreign key constraint.
允许您选择通过创建外键约束来实现父表和子表之间的引用完整性。
This category of overhead includes CHECK constraint verification and foreign key constraint (referential integrity (ri)) verification.
这一类的开销包括检查约束验证和外键约束(参照完整性(RI))验证。
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。
When you select the type, the appropriate dialog box opens (Unique constraint or Foreign Key constraint) to help you create the constraint.
显示适当的对话框(唯一约束或外键约束),从而允许您更改约束的属性。
A key constraint on the project was that the cost of operating the system could not cost anymore after the migration than it did before the migration.
关于该项目的主要制约因素是,该系统的运作成本不能迁移后的成本比在迁移之前做了。
Errors that are raised during the EXECUTE or FETCH phase of execution, such as a unique key constraint violation, can be returned in more than one way.
对于在执行期间的EXECUTE或FETCH阶段产生的错误,比如uniquekey constraint违背,可以以多种方式返回。
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之间那样。
After converting successfully from version 11.50.xc7 to 11.70.xc1, you can use the following commands to create a foreign key constraint with index disabled.
成功地由版本11.50 .xC 7升级到11.70 .xC1之后,您可以使用以下命令,创建一个索引禁用的外键约束。
Additionally, there cannot be a foreign key constraint between the table being truncated and other tables, otherwise the truncate table operation fails.
此外,被truncate的表和其他表之间是不能有外键约束的,否则truncateTABLE操作会失败。
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.
注意,如果物理文件使用了键控(可能因为它有一个PrimaryKey约束),其隐式索引也将通过这些命令被移动到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所示,两个示例记录中的批量加载操作结果被发送给拒绝链接,因为它们违反唯一的主键约束。
If a dataset contains constraints (such as a foreign-key constraint) it is possible to cause exceptions to be thrown depending on the order of operations performed against the dataset.
如果数据集包含约束(如外键约束),则可能导致引发异常,取决于对数据集执行操作的顺序。
应用推荐